Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I just need help with G and H. Please include math. Thank you! EYK9-1. Business Decision Case The sales department of Donovan Manufacturing, Inc. has
I just need help with G and H. Please include math. Thank you!
EYK9-1. Business Decision Case The sales department of Donovan Manufacturing, Inc. has completed the following sales forecast for the months of January through March 20X1 for its only two products: 50,000 units of J to be sold at $90 each and 30,000 units of K to be sold at $70 each. The desired unit inventories at March 31, 20X1, are 10% of the next quarter's unit sales forecast, which are 60,000 units of J and 30,000 units of K. The January 1, 20X1, unit inventories were 5,000 units of J and 2,000 units of K. Each unit of J requires 3 pounds of material A and 2 pounds of material B for its manufacture; K requires 2 pounds of A and 4 pounds of B. The purchase cost of Ais $9 per pound and the purchase cost of B is $5 per pound. Materials A and B on hand at January 1, 20X1, were 19,000 pounds of A and 7,000 pounds of B. Desired inventories at March 31, 20X1, are 14,000 pounds of A and 8,000 pounds of B. Each unit of J requires 0.5 hours of direct labor in the factory; each unit of K requires 1.0 hour of direct labor. The average hourly rate for direct labor is $12 per hour. Estimated manufacturing overhead cost is $6 per direct labor hour plus $90,000 per month. Selling and administrative expenses are estimated to be 10% of sales revenue plus $180,000 per month. Cash sales for the first quarter are estimated to be $300,000 per month. It is forecast that 30% of the credit sales for the quarter ended March 31, 20X1, will occur in January, 30% in February, and 40% in March. Of credit sales (December through March), 40% will be collected as cash in the month of sale and 55% will be collected in the following month. The remainder will be uncollectible. Cash collected in January 20X1 from December 20X0 sales will be $1,050,000. The January 1, 20X1, cash balance was $70,000. The minimum acceptable cash balance at the end of each month is $60,000. Short-term borrowings (6-month term) are made in multiples of $10,000. Interest is charged at the rate of 1% per month on short-term borrowings. The first interest payment is made the month following the borrowing. Cash disbursements (excluding interest on short-term borrowings) are estimated as follows: January February March Manufacturing costs.. $1,500,000 $1,300,000 $1,400,000 390,000 410,000 400,000 Selling and administrative expenses 90,000 90,000 90,000 Interest expense.. 0 0 210,000 Income tax payment. 124,000 110,000 50,000 Capital expenditures.. 0 0 300,000 Cash dividends.. Required a. Prepare the sales budget for the quarter ended March 31, 20X1. b. Prepare the production budget for the quarter ended March 31, 20X1. c. Prepare the direct materials budget for the quarter ended March 31, 20X1. d. Prepare the direct labor budget for the quarter ended March 31, 20X1. Prepare the manufacturing overhead budget for the quarter ended March 31, 20X1. f. Prepare the selling and administrative expense budget for the quarter ended March 31, 20X1. 8. Prepare a schedule of cash collected from customers for the quarter ended March 31, 20X1. h. Prepare the cash budget for the quarter ended March 31, 20X1. e. Donovan Manufacturing, Inc. Sales budget For the Quarter Ended March 31, 20X1 Product J K Total sales revenue Forcasted sales volume Planned unit sales price Budgeted total sales 50,000 $ 90.00 $ 4,500,000 30,000 $ 70.00 2,100,000 6,600,000 $ Donovan Manufacturing, Inc. Production budget For the Quarter Ended March 31, 20x1 Units of finished product Product Product K 50,000 30,000 Forcast unit sales Desired ending inventory 6,000 Quantities to be available Less: Beginning Inventory Total production to be scheduled 56,000 5,000 51,000 3,000 33,000 2,000 31,000 c Donovan Manufacturing, Inc. Direct materials budget For the Quarter Ended March 31, 20X1 Material A Material B 153,000 102,000 62,000 Direct material required: Product (3 lbs/unit) (2 lbs/unit) Product K (2 lbs/unit) (4 lbs/unit) Desired ending material inventory Total pounds of material to be available Less: Beginning Inventory Total pounds of material to be purchased Unit purchase price Total materials purchases 14,000 229,000 19,000 210,000 9.00 $ 1,890,000 $ 124,000 8,000 234,000 7,000 227,000 5.00 1,135,000 $ $ Donovan Manufacturing, Inc. Direct labor budget For the Quarter Ended March 31, 20X1 Direct labor hours required for production: Product Product K Total direct labor hours Hourly Rate for Direct Labor Total direct labor cost 25,500 31,000 56,500 12.00 678,000 $ Donovan Manufacturing, Inc. Manufacturing overhead budget For the Quarter Ended March 31, 20x1 Total direct labor hours Variable Cost per Direct Labor Hour Total Variable Manufacturing Overhead Fixed manufacturing overhead costs Total manufacturing overhead cost $ $ 56,500 6.00 339,000 270,000 609,000 $ Donovan Manufacturing, Inc. Selling and administrative expense budget For the Quarter Ended March 31, 20X1 $ Total sales revenue Variable Costs Total Variable Costs Fixed selling and administrative expenses Total selling and administrative expenses $ 6,600,000 10% 660,000 540,000 1,200,000 $ Donovan Manufacturing, Inc. Schedule of cash collected from customers For the Quarter Ended March 31, 20x1 January February March $ 300,000 $ 300,000 $ 300,000 $ 1,050,000 684,000 Cash sales Credit sales December January February March Total credit sales Total sales 940,500 684,000 940,500 912,000 1,852,500 2,152,500 1,734,000 2,034,000 $ 1,624,500 1,924,500 $ $ Donovan Manufacturing, Inc. Cash budget For the Quarter Ended March 31, 2019 January February $ 70,000 $ 60,000 March $ Beginning cash balance Cash receipts: Cash Sales Collections from Customers Short Term Borrowing Cash available 300,000 $ 1,624,500 300,000 1,852,500 300,000 $ 1,734,000 360,000 2,464,000 $ $ 1,984,500 $ 2,152,500 1,500,000 390,000 90,000 1,300,000 410,000 90,000 Cash disbursements: Manufacturing Costs Selling & Administrative Expenses Interest Expense Income Tax Payment Capital Expenditures Cash Dividends Total disbursements Ending cash balance 1,400,000 400,000 90,000 210,000 50,000 110,000 124,000 300,000 2,404,000 60,000 $ 1,910,000 74,500 $ 2,150,000 2,500 $Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started