Question

In: Accounting

1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The...

1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January.

2. End of month inventory must equal 40% of next month’s sales. The inventory at the end of December was 150 units.

3. The following are the expected costs for direct materials, direct labor and manufacturing overhead:

DM                              DL                                         Overhead

January          $15/unit                     $28/unit              $15,500 + $8.00 per unit produced     

February        $15/unit                     $28/unit              $15,500 + $8.00 per unit produced

March          $15/unit                      $28/unit              $15,500 + $8.00 per unit produced

A. Direct materials are paid 60% in the month incurred and 40% in the following month.

      Account payable for materials at the end of December is $2,900; this amount will be paid in January.

B. Direct labor is paid in the month incurred.

C. Overhead costs are paid in the month incurred. Fixed overhead includes depreciation of $7,000 per month.

4.   Selling costs are sales commissions: $5 per unit sold; shipping costs: $1 per unit sold. Administrative costs per month are: salaries: $3,000; rent: $2,000; depreciation: $1,500. All costs are paid in the month incurred.

5. The company plans to purchase equipment in January costing $15,000 and will pay for it in cash.

6. The company plans to pay $4,500 cash dividends in February.

7. The cash balance as of December 31 is $25,050. The company borrows money only if the cash balance falls below $5,000 at the end of the month. The company has a revolving credit with US Bank to borrow in increments of $1,000 at the beginning of each month at interest of 12% annual rate. The company repays interest at the end of each month and principle (or portion) at the end of the month when they have the resources to do so. As of December 31, the company has no outstanding loans.

Required:

Based on the information given, prepare the following budgets for each month of the first quarter of 2020 and the quarter totals:

  1. Sales Budget, including a schedule of expected cash collections;
  2. Production Budget (in units);
  3. Direct material, including schedule of expected cash disbursements;
  4. Direct labor budget;
  5. Manufacturing Overhead Budget;
  6. Selling and Administrative Expenses Budget;
  7. Cash Budget.

So I just posted this question and I am sorry to ask this but is there any way that I can see the typed up version of the answer for this please? I couldn't really read the handwriting on the last one and the pictures were really blurry. Please help, trying to check my answers. If I need to repost it again to get everything I will but I need something legible please. Thank you.

Solutions

Expert Solution


Related Solutions

1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The...
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month inventory must equal 40% of next month’s sales. The inventory...
Information for 2020: 1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April:...
Information for 2020: 1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month inventory must equal 40% of next month’s...
Information for 2019: 1.   Sales forecast: January: 2,100 units; February: 2,900 units; March: 3,300 units; April:...
Information for 2019: 1.   Sales forecast: January: 2,100 units; February: 2,900 units; March: 3,300 units; April: 3,500 units. The unit sales price is $50. All sales are on credit and collections are 20% in the month of sale and 80% the following month. Accounts receivable as of December 31, 2018 is $15,000 and this amount is expected to be collected in January 2019. 2. End of month inventory must equal 60% of next month’s sales. The inventory at the end...
Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units)...
Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, MATT, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told MATT his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information...
Grover has forecast sales to be $128,000 in February, $137,000 in March, $151,000 in April, and...
Grover has forecast sales to be $128,000 in February, $137,000 in March, $151,000 in April, and $148,000 in May. The average cost of goods sold is 70% of sales. All sales are on made on credit and sales are collected 60% in the month of sale, and 40% the month following. What are budgeted cash receipts in March? $133,400 $96,900 $137,400 $94,100
Month Actual Sales Forecast Sales January 8 10 February 11 10 March 12 10 April 14...
Month Actual Sales Forecast Sales January 8 10 February 11 10 March 12 10 April 14 10 -Compute the RSFE, MAD and tracking signals for months January to April?
***ONLY NEED QUESTIONS 6 & 7 ANSWERED*** Information for 2020: 1.   Sales forecast: January: 2,600 units;...
***ONLY NEED QUESTIONS 6 & 7 ANSWERED*** Information for 2020: 1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month...
Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500...
Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $9,000 per year, using the straight-line method. He has supplied you with the following information (above) to help you...
Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500...
Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information (above) to...
Month: Radiology Tests:   Total Costs: January 2,800    $133,500 February 2,600 $135,060 March 3,100 $175,000 April...
Month: Radiology Tests:   Total Costs: January 2,800    $133,500 February 2,600 $135,060 March 3,100 $175,000 April 3,500 $170,600 May 3,400 $176,900 June 3,700 $186,600 July 3,840 $174,450 August 4,100 $195,510 September 3,450 $15,300 1. Compute the cost formula for radiology services using the method of least square 2. Using the formula computed in requirement 1, what is the predicted cost of radiology services for October for 3,500 appointments? (Round the answer to the nearest dollar) 3. What does the coefficient...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT