Please write show all Excel Work

Please write show all Excel Work

Schedule 2 Guide:

EXERCISE 82 Production Budget QL08-3 Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows: Unit Sales April 50,000 May 75,000 June 90,000 July 80,000 The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-of- month inventory levels must equal 10% of the following month's unit sales. The inventory at the end of March was 5,000 units. Required: Using Schedule 2 as your guide, prepare a production budget by month and in total, for the second quarter. Next A D E F 1 2 B Hampton Freeze, Inc. Production Budget For the Year Ended December 31, 2021 (in cases) 3 4 5 Assumed 6 Quarter 2 3 7 1 4 Year 10,000 30,000 40,000 20,000/ 100,000 20% 20% 20% 6,000 8,000 4,000 3,000 3,000 8 Budgeted unit sales (Schedule 1) 9 Add desired units of ending finished goods inventory* 10 Total needs 11 Less units of beginning finished goods inventory 12 Required production in units 16,000 38,000 44,000 23,000 103,000 2,000 6,000 8,000 4,000 2,000+ 14,000 32,000 36,000 19,000 101,000 13 Schedule 2 Schedule 3 Schedule 4 Schedule 5 Schedule 6 S