Data REVIO Formulas Custom Page Layout Wrap Text come 14 Liberation Sans $ - % ) Insert X Cut " Format Merge & Center 1 Onion Update To keep up-to-date with security updates, foxes, and improvements, choose Check for Updates 22 xf Function I Farma Mpy SLCel Referendag Using End to Prepare a state and Flexible Direct Laber Student Work Area Required Provide input into cell shaded in yellow in this template. Le mathematical formulas with cell references to the Problem sa or work area as indicated. Use the IF Medic with all resto labelske ordenie PROBLEM Roy Cowy rowded be following inson needed for departient of and flexible budget porte during 2000 Prepare the following budget reports for January, 2020 sing Excel's IP function, and evaluate the finess of each report Attic budget repen Dhe per leber how Anala amuary pedir er housemat Actualhorary $ 2000 $20.000 0.000 16,00 Rooney Cospany Statie Diet Labor Budget Report For the Month Ended Jay 112020 Budget Actual Difference 1 Direct labor Axible bude Rooney Company Plexible Direct Labor Budget Report For the Month Endau 11.2000 Hader A Duference De ahor Esthes of short heit performance on the proporbus for line perfume MacBook Air Keep up-to-date with security updates, fixes, and improvements, choose Check for Updates H35 X & fic A E F H 1 Function: SUM; Formula: Subtract, Multiply: Cell Referencing D Student Work Area Required Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area of this work area as indicated. Use the SUM function with cell referencing for Total Prepare a production budget by quarters for the first 6 months of 2020 Using Excel to Prepare a Production Budget PROBLEM 5 Paige Company estimates that following unit sales and desired inventory 6 level for the first three quarters of the year ending December 31, 2020. B Quarter sales 10.000 10 Quarter 2 sales 14,000 Quarter 3 sales 15,000 Desired ending finished goods inventory based on next quarter's expected unit sales 25% 14 15 515 Paige Company Production Budget For the Six Months Ending June 10, 2020 Quarter 10,000 Six Months Quarter 2 14.000 Expected unit sales Add: desired ending finishing goods inventory 3.500 total units required 13.500 17,750 Less beginning inventory SHNA 2.500 1 units to be produced 11.000 14.20 24 25 26 30 31 35 ste B Format Omice Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. 35 x x D E G Function: SUM: Formula: Subtract, Multiply: Cell Referencias Using Excel to Prepare a Production Budget PROBLEM Paige Company estimates that following unit sales and desired inventory level for the first three quarters of the year ending December 31, 2020, Student Work Area Required Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area of this work area as indicated. Use the SUM function with cell referencing for Prepare a production budget by quarters for the first 6 months of 2020 9 10 11 10.000 14,000 15,000 Quarter sales Quarter 2 sales Quarteles Desired ending finished goods inventory med on next quarter's expected unit les Paige Company Production Budget For the Six Month Ending June 30, 2020 Quarter 1 10,000 25% Six Months Quarter 2 14,000 Expected unit les 14 15 16 3.7509 3.500 Add desired ending finishing goods inventory 13.500 total units required 17,750 2.600 2.500 10 30 21 23 Lebegning loventory 11.000 14.250 2250 units to be produced 25 26 71 26 20
