A B C D E 1 Function: SUM; Formula: Subtract, Multiply; Cell Referencing 2 3 Using Excel to Prepare a Production Budget 4 PROBLEM 5 Paige Company estimates that following unit sales and desired 6 inventory level for the four quarters of the year ending 7 December 31, 2022. 8 9 Quarter 1 sales 10,000 10 Quarter 2 sales 14,000 11 Quarter 3 sales 15,000 12 Quarter 4 sales 18,000 13 Desired ending finished goods inventory 14 based on next quarter's expected unit sales 25% 15 Unit selling price $ 70.00 16 17 Prepare a production budget by quarters for the first 6 months 18 of 2022. 19