I ONLY NEED QUESTION 5,6,& 7 PLEASE

DUE AT MIDNIGHT

AutoSave OFF OFF A SU CASE 2 - Master Budget 20FA - Compatibility Mode Home Insert Draw Design Layout References Mailings Review View RCM Tell me Share Comments X Aav I 21 Times New... V 12 "Ai B! BI U au XX 4o8.Code AaBbCcDc An CDE ARCDI Empheals Headina Normal Strong AaBande AaBbce Subtite Thia Paste Dictate Y Styles Pane Sensitivity MANAGERIAL ACCOUNTING CASE 2 - PREPARATION OF A MASTER BUDGET Information for 2020: Saks forecast: January 2,400 units; Forenry: 4,300 units, March 11,900 units; April 13,000 units. The unit sales price is $130. All sales are on credit and collections are in the month of sale, 55% the following month, and 15% two months following the sale. Accounts receivable as of December 1 is $9,500 ($9,600 is expected to he collected in Innuary and the remainder in Felrary). 2. End of months in custoty must equal 40% of next month's sales The inventory at the end of December Wis 1.1 5 units The following are the expected coses for dirext materials, direct labor and manufacturing overhend: DMDL Overhead Jiuuiry $16'un S29/unit $17,000 - $8.10 per unit produced February S16'units29anit $17,000 - $8.10 per unit produced March $16'unit $29/unit $17,000+ $8.10 per unit produced A Direct materials ne paid in the month incurred and 40% in the following month Acceuil payable for storials as of Doombu 31 is $2,450, Ils out will be paud in Jay. B. Direct labor is paid in the moontla locurred. C Overhead costs are paid in the months incurred. Fixed ovcrbad includes depreciation of $7,000 per mouth 4. Selling and administrative cols are comprised of sales couissies: S5.20 per uul sold, slipping costs $3 porwa sok; salaries $4,000, scal: S2,500; depreciation: $2,000. All costs are paid in the bomb incurred. 3. The company plans to pay $6,000 cash dividends in January 6. The company plans to buy cycuperal. colung S16,500 W be paid in cash in February 7. The cast balance as of Daxmber 31 543,100. The cultipy burrows money only if the cash babano below S15,000 at the end of the month. The company has a revolving credit with US Bank to borrow at the beginning of each mooth at interest of 12% annual rate. The company repaya interest at the end of each month and principle (ur purlion) at the cod of the conth when they have the resources to do so. As of December 31, the company has no oulstanding loans. Recuredi Based on the information given, prepare the following budgets for sach month of the first quarter of 2020 and the quarter totals: 1. Sales Budget, including a schodule of expected cash collections, 2. Production Budget (nils 1. Direct material, including schedule of expected cash disbursements; 4. Direct labur budget; 5. Manufacturing Overhead Buigel; 6. Selling and Administrative Expenses Budget: 7. Cash Budget. Page 1 of 836 words LE English (United States) Focus E + 100% % AutoSave OFF OFF A SU CASE 2 - Master Budget 20FA - Compatibility Mode Home Insert Draw Design Layout References Mailings Review View RCM Tell me Share Comments X Aav I 21 Times New... V 12 "Ai B! BI U au XX 4o8.Code AaBbCcDc An CDE ARCDI Empheals Headina Normal Strong AaBande AaBbce Subtite Thia Paste Dictate Y Styles Pane Sensitivity MANAGERIAL ACCOUNTING CASE 2 - PREPARATION OF A MASTER BUDGET Information for 2020: Saks forecast: January 2,400 units; Forenry: 4,300 units, March 11,900 units; April 13,000 units. The unit sales price is $130. All sales are on credit and collections are in the month of sale, 55% the following month, and 15% two months following the sale. Accounts receivable as of December 1 is $9,500 ($9,600 is expected to he collected in Innuary and the remainder in Felrary). 2. End of months in custoty must equal 40% of next month's sales The inventory at the end of December Wis 1.1 5 units The following are the expected coses for dirext materials, direct labor and manufacturing overhend: DMDL Overhead Jiuuiry $16'un S29/unit $17,000 - $8.10 per unit produced February S16'units29anit $17,000 - $8.10 per unit produced March $16'unit $29/unit $17,000+ $8.10 per unit produced A Direct materials ne paid in the month incurred and 40% in the following month Acceuil payable for storials as of Doombu 31 is $2,450, Ils out will be paud in Jay. B. Direct labor is paid in the moontla locurred. C Overhead costs are paid in the months incurred. Fixed ovcrbad includes depreciation of $7,000 per mouth 4. Selling and administrative cols are comprised of sales couissies: S5.20 per uul sold, slipping costs $3 porwa sok; salaries $4,000, scal: S2,500; depreciation: $2,000. All costs are paid in the bomb incurred. 3. The company plans to pay $6,000 cash dividends in January 6. The company plans to buy cycuperal. colung S16,500 W be paid in cash in February 7. The cast balance as of Daxmber 31 543,100. The cultipy burrows money only if the cash babano below S15,000 at the end of the month. The company has a revolving credit with US Bank to borrow at the beginning of each mooth at interest of 12% annual rate. The company repaya interest at the end of each month and principle (ur purlion) at the cod of the conth when they have the resources to do so. As of December 31, the company has no oulstanding loans. Recuredi Based on the information given, prepare the following budgets for sach month of the first quarter of 2020 and the quarter totals: 1. Sales Budget, including a schodule of expected cash collections, 2. Production Budget (nils 1. Direct material, including schedule of expected cash disbursements; 4. Direct labur budget; 5. Manufacturing Overhead Buigel; 6. Selling and Administrative Expenses Budget: 7. Cash Budget. Page 1 of 836 words LE English (United States) Focus E + 100% %