Question

Final Answers Here Please Income Statement Amounts Other Amounts 5 Units Sold * Selling Price 7 Pounds Per Direct Materials 3 DL Per OH Rate • Current Finished 7 Target Finished 2 Current DM 3 Target DM 4 Cost Per DM 5 Cost Per DL 2,500 $ 100.00 3.00 2.00 $ 15.00 300 200 100 200 $ 5.00 $ 20.00 Sales Direct Materials Direct Labor Overhead Production Budget Direct Materials Budget (in pounds) Direct Labor budget (in hours) Total Costs Gross Profit 90 Jensen Manufacturing has the following information relating to their master budget for 2020 -0 Units Sold Selling Price Pounds of Direct Materials Per Unit Manufactured DL Hours Per Unit Manufactured OH Rate Per DL Hour Current Inventory of Finished Product Target Inventory of Finished Product Current Inventory of Direct Materials E6 Target Inventory of Direct Materials 7 Cost per Pound of Direct Material - Cost per Direct Labor Hour 2,500 units $100 per unit 3 pounds 2 hours $15 per hour 300 units 200 units 100 pounds 200 pounds $5.00 per pound $20.00 per hour 0 Required On the spreadsheet provided, prepare the following: • Sales Budget • Production Budget in Units 249 29 • Direct Materials Budget in Units and Dollars • Direct Labor Budget in Hours and Dollars • Overhead Budget in Dollars • Gross Profit Budget

Please post on excel spreadsheet to show formula. Thank you

Answer 1

Incomet statement Amounts
	Amount($)
Sales	250000
Direct materials	37500
Direct labour	100000
Overhead cost	75000
Total cost	212500
Gross Profit	37500	15
Sales Budget
	In units	In $
Sales budget	2600
Production Budget	2800		2500+300
Direct materials Budget	8700	43500	3*2900
Direct Labour budget	5600	112000	2*2800
Overhead Budget		84000	2*15*2800
Gross Profit budget		39000