Do all please, will leave thumbs up.

F G A B D E 1 Excel Project #2 2 Complete the Sales Budget, Production Budget, and Materials Budget for the quarter ending June 30, 2021. 3 4. Data Sheet for Master Budget Problem 5 6 1.) Unit sales for the quarter are as follows: 7 April 7,500 8 May 16,750 9 June 23,000 10 July 14,250 11 August 22,500 12 The selling price for each unit is: $67 13 2.) The company has set a policy that the ending finished goods inventory should be the following percentage of next period's sales units. This policy 14 has been followed in the prior period. 25% 15 16 3.) The materials required for each product are: 4.25 pounds 17 The price per pound is: $3.25 18 4.) Desired ending inventory of materials should be the following 19 percentage of the next period's production needs for materials. 15% 20 21 Sales Budget for the Quarter Ending June 30, 2021 April May June Quarter July August 1 2 3 4 # of Units 5 Price per Unit 5 Sales Dollars 7 * *** $0 $0 $0 $0 July Sales are needed to calculate the Production Budget desired ending inventory for June August Sales are needed to calculate the Production needs for July to caculate Materials Budget desired ending inventory for June 0 ** 1 2 A E F G H B D Production Budget for the Quarter Ending June 30, 2021 April May June Quarter July * August * Sales Units Plus: Desired Ending Inventory = Total Inventory Requirements - Beginning Inventory = Budgeted Production 0 July Production Needs are needed to calculate the Materials Budget desired ending inventory for June ) 1 August Sales are needed to calculate the Production needs for July to caculate Materials Budget desired ending inventory for 2 Materials Budget for the Quarter Ending June 30, 2021 July Current Production Needs (needed to calculate June's Materials Desired Ending Inventory) April May June Quarter Budgeted Units to Produce * Lbs of Materials Per Unit = Materials for Current Production + Desired Ending Inventory = Material Needs Beginning Inventory = Materials to Purchase * $ per Lb. = Cost of Materials B 7