Using Excel to Prepare a Production Budget PROBLEM Paige Company estimates that following unit sales and desired inventory level for the four quarters of the year ending December 31, 2022. _ Quarter1 sales 10,000 7 Quarter 2 sales 14,000 _ Quarter 3 sales 15,000 _ Quarter 4 sales 18,000 _ Desired ending finished goods inventory _ based on next quarter's expected unit sales 25% Unit selling price $ 70.00 Prepare a production budget by quarters for the first 6 months of 2022. Paige Company Production Budget For the Six Months Ending June 30, 2022 Quarter 1 Quarter 2 Six Months Expected unit sales 10,000 14,000 Add: Less