tion: SUM; Formula: Subtract, Multiply; Cell Referencing g Excel to Prepare a Production Budget PROBLEM ge Company estimates that following unit sales and desired entory level for the four quarters of the year ending December 31, 22. Quarter 1 sales Quarter 2 sales Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or this work area as indicated. Use the SUM function with cell referencing for totals. Paige Company Production Budget Quarter 3 sales Quarter 4 sales Desired ending finished goods inventory 10,000 14,000 15,000 For the Six Months Ending June 30, 2022 18,000 Quarter 1 Quarter 2 Six Months Expected unit sales 10,000 14,000 25% $ 70.00 Add: Desired ending finished goods units 10,000 14,000 Total required unit 3,500 3,750 Less: Beginning finished goods units 2,500 3,500 Required production units 11,000 14,250 25.250 based on next quarter's expected unit sales Unit selling price Prepare a production budget by quarters for the first 6 months of 2022 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or this work area as indicated. Use the SUM function with cell referending for totals Expected unit Add LOVE: Paige Company Production Budget For the Six Months Ending June 30, 2022 Quarter 1 Quarter 2 Six Months Co C10 CELA HISTRIA COUNCI OPCH 0154/17/18 ISHITICIS 21-23 Function: SUM; Formula: Subtract, Multiply; Cell Referencing 3 Using Excel to Prepare a Production Budget 4 PROBLEM Paige Company estimates that following unit sales and desired 6 inventory level for the four quarters of the year ending December 31, 72022 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or this work area as indicated. Use the SUM function with ce referencing for totals. 9 Quarter 1 sales 10 Quarter 2 sales 11 Quarter 3 sales 10,000 14,000 15,000 Paige Company Production Budget For the Six Months Ending June 30, 2022 12 Quarter 4 sales: 18,000 13 Desired ending finished goods inventory Expected unit sales 14 15 based on next quarter's expected unit sales Unit selling price 25% $ 70.00 Add: Osired ending finished goods uni 16 18 17 Prepare a production budget by quarters for the first 6 months of 2022 19 20 21 Quarter 1 10,000 Quarter 2 14,000 Six Months 10,000 14,000 3.500 3750 Lessing the goodsunita 2.500 3,500 Required production unt 11,000 14,250 21,250 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or this work area as indicated. Use the SUM function with cell referencing for totals. Expected unit Add Desired ending trished goods Total required units Loss Begning frishal grade units Paige Company Production Budget For the Six Months Ending June 30, 2022) Quarter 1 Quarter 2 Six Months C9 010 SCIA COURCHE C10 C14 015417122 (352)