Question

1. Prepare a sales budget for January through May. The selling price per unit is $40.00....

1. Prepare a sales budget for January through May. The selling price per unit is $40.00. December of the previous year-40,000 January-90,000 February-80,000 March-70,000 April-40,000

2. Prepare a purchases budget for January through March, and the first quarter in total. Assume that the company only sells one product that can be purchased at $15.00 per unit. The market for this product is very competitive and customers highly value service such as quality and on time delivery of the product. Also assume that currently it is company policy that ending inventory should equal 90% of next month’s projected sales.

3. Prepare a cash budget for January through March and for the first quarter in total. The company maintains a minimum cash balance of $50,000.00, and this was the balance in the cash account on January 1. Past experience shows that 30% of sales are collected in the month of the sale, and 70% in the month following the sale. Labor cost is $15 per unit. Other expenses include $37,000 per month for rent, $4,000 for advertising, and $6,000 per month for depreciation. All costs are paid in the current month except inventory purchases, which are paid in the month following purchase (i.e. January purchases are paid in February). On January 1st there was an accounts receivable balance of $60,000 and an outstanding accounts payable balance of $100,000. The company has an open line of credit with a bank and can borrow at an annual rate of 12%. For simplification assume that all loans are made at the beginning of the month when borrowing is needed and repayments are made at the end of a month when there is enough cash to make the payment. Also, interest is only paid at the time when a repayment is made. Additionally, all loans and repayments (not the interest portion) can only be made in increments of $1000 and the company would like to pay its debts, or a portion thereof, as soon as it has enough cash to do so. 4. Prepare the Budgeted Income Statement based on the information given above.

I solved questions 1-3, but I need help with #4. Thanks!

Homework Answers

Answer #1
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.
4. Budgeted Income for Jan-Mar
Sales (90000+80000+70000)*40 $9,600,000
Less: Cost of Goods Sold (90000+80000+70000)*15 $3,600,000
Less: Labor (90000+80000+70000)*15 $3,600,000
Less: Rent 37000*3 $   111,000
Less: Advertising 4000*3 $     12,000
Less: Depreciation 6000*3 $     18,000
Net Operating Income $2,259,000
Less: Interest Expense From Cash Budget
Net Income $2,259,000
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
1. Prepare a sales budget for January through May. The selling price per unit is $40.00....
1. Prepare a sales budget for January through May. The selling price per unit is $40.00. December of the previous year 40,000 January 90,000 February 80,000 March 70,000 April 40,000 2. Prepare a purchases budget for January through March, and the first quarter in total. Assume that the company only sells one product that can be purchased at $15.00 per unit. The market for this product is very competitive and customers highly value service such as quality and on time...
1. Prepare a sales budget for January through May. The selling price per unit is $40.00....
1. Prepare a sales budget for January through May. The selling price per unit is $40.00. December of the previous year-40,000 January-90,000 February-80,000 March-70,000 April-40,000 2. Prepare a purchases budget for January through March, and the first quarter in total. Assume that the company only sells one product that can be purchased at $15.00 per unit. The market for this product is very competitive and customers highly value service such as quality and on time delivery of the product. Also...
The selling price per unit is $50.00 December of the previous year 20,000 January                            &nbsp
The selling price per unit is $50.00 December of the previous year 20,000 January                                     40,000 February                                   60,000 March                                       80,000 April                                         100,000                            Prepare a purchases budget and the schedule for Disbursements for Purchases for January through March and for the first quarter in total. Assume that the company only sells one product that can be purchased at $35.00 per unit. The market for this product is very competitive and customers highly value quality and on time delivery of the product. Also assume that currently...
Maleficent Company Limited is preparing budget based on the information below. 1. Budget sales revenues: January...
Maleficent Company Limited is preparing budget based on the information below. 1. Budget sales revenues: January February March $ $ $ Credit sales 550,000 450,000 650,000 Cash sales 65,000 55,000 55,000 Total sales 615,000 505,000 705,000 Past experience indicates that customers usually settle their balances as follows: - 60% of a month's credit sales are collected in the month of sale; and - the remaining 40% of a month's credit sales are collected in the following month. All purchases are...
The Bear Corporation will begin business operations on January 1, 2015. Below is the anticipated SALES...
The Bear Corporation will begin business operations on January 1, 2015. Below is the anticipated SALES BUDGET (in units):    Jan.                 __0,000 Feb.                 __0,000 Mar.                __0,000 Apr.                __0,000 May                __0,000    To complete the unit sales forecast, use the third, fourth, fifth and sixth digits of your student identification number to fill in the blanks.   If any of these digits contains a "0", use "3" instead.                     Example:   If student ID number is 00607357.   The sales forecast would be: January           ...
Mary, Heidi, Steve and, Roger planned to open up a cosmetic distributor outlet in Paris next...
Mary, Heidi, Steve and, Roger planned to open up a cosmetic distributor outlet in Paris next year. They are in the process of assembling a cash budget for the first quarter of the year 2020. They asked you to help them to prepare a cash budget and provide you with the following information: They will start the business in January 2020, with $90,000 cash as the capital. They will rent a double-story building. They need to pay a rental deposit...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six months of 2010 are as follows: Month Unit Sales Month Unit Sales January 130,000 April 190,000 February 160,000 May 190,000 March 190,000 June 230,000 Beginning inventory for 2010 is 40,000 units. The budgeted inventory at the end of a month is 20 percent of units to be sold the following month. Purchase price per unit is $3. Prepare a purchases budget in units and...
The sales budget is provided below for the product of Company ABC. Jan 30,000 units Feb...
The sales budget is provided below for the product of Company ABC. Jan 30,000 units Feb 20,000 units Mar 10,000 units Apr 20,000 units May 30,000 units Finished goods at the end of each month must be 10% of the next month’s budgeted sales. On Dec 31 of the last year, the finished goods totaled 2,000 units. The selling price is $1 per unit. 80% of the credit sales are collected in the month of sale, 15% in the month...
The PM Company has planned the following sales for the next three months: January February March...
The PM Company has planned the following sales for the next three months: January February March Budgeted Sales $40,000 $50,000 $70,000 Sales are made 20% for cash and 80% on account (A/R). From experience, the company has learned that a month's sales on account are collected according to the following pattern: Month of sale: 60% First month following sale: 30% Second month following sale: 8% Uncollectible: 2% The following additional information has been provided for March: Inventory purchases (70% paid...
Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling...
Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company’s accounting records: All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 35 percent are collected in the following month. Uncollectibles amounting to 5 percent of sales are anticipated, and management believes that only 20 percent of the accounts...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT