week 6

profilehlove23
CopyofWeek6HomeworkChapters2223_Question30.xlsx
Home>Business & Finance homework help>Accounting homework help>week 6

Enter Answer

Function: SUM; Formula: Subtract, Multiply; Cell Referencing
Using Excel to Prepare a Production Budget Student Work Area
PROBLEM 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 estimates that following unit sales and desired inventory level for the four quarters of the year ending December 31, 2022.
Some cells are merged.
Quarter 1 sales 10,000 Paige Company
Quarter 2 sales 14,000 Production Budget
Quarter 3 sales 15,000 For the Six Months Ending June 30, 2022
Quarter 4 sales 18,000 Quarter 1 Quarter 2 Six Months
Desired ending finished goods inventory Expected unit sales 10,000 14,000
based on next quarter's expected unit sales 25%
Unit selling price $ 70.00 Add:
Prepare a production budget by quarters for the first 6 months of 2022.
Less:

Author: Answer Field 7.6% of your score. Function: SUM; Cell reference. Use the SUM function with cell references to this work area.
Author: Answer Field 7.7% of your score. Drop-down selection. Select the correct label from the drop-down list.
Author: Answer Field 7.7% of your score. Drop-down selection. Select the correct label from the drop-down list.
Author: Answer Field 7.7% of your score. Formula: Multiply; Cell reference. Input a mathematical formula with cell references to the Problem area.
Author: Answer Field 7.7% of your score. Formula: Multiply; Cell reference. Input a mathematical formula with cell references to the Problem area.
Author: Answer Field 7.7% of your score. Function: SUM; Cell reference. Use the SUM function with cell references to this work area.
Author: Answer Field 7.7% of your score. Drop-down selection. Select the correct label from the drop-down list.
Author: Answer Field 7.7% of your score. Drop-down selection. Select the correct label from the drop-down list.
Author: Answer Field 7.7% of your score. Function: SUM; Cell reference. Use the SUM function with cell references to this work area.
Author: Answer Field 7.7% of your score. Formula: Multiply; Cell reference. Input a mathematical formula with cell references to the Problem area.
Author: Answer Field 7.7% of your score. Cell reference. Input a cell reference to the this work area.
Author: Answer Field 7.7% of your score. Formula: Subtract; Cell reference. Input a mathematical formula with cell references to this work area.
Author: Answer Field 7.7% of your score. Formula: Subtract; Cell reference. Input a mathematical formula with cell references to this work area.