PROBLEM

GIVEN TAB INFO

BUDGET TAB INFO

Instructions 1 The student is required to complete the budget assignment using the template provided on the "Budget" tab of this file. 2 The cells with orange fill are where the data is to be entered. Formulas are required in ALL cells (no hard-coded numbers). Part of this assignment is assessing your ability to use Excel. The Data for these formulas is in the "Given" tab of this file. 3 formulas in any of the cells of one of the budgets, only 25% of the points possible will be awarded instead of the full 50% ). OPTIMA, INC. Additional information: Ending finished goods inventory (percentage of the next quarter's sales) Ending raw materials inventory (percentage of the next quarter's production) Expected number of frames sold in following quarters: Borrowing increments $1 $250,000 Quarterly dividend payments Regarding Inventory: Work-in-process has a zero beginning and ending balance. Direct Materials Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Purchased - Used = Ending) Finished Goods Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Produced - Sold = Ending) Instructions 1 The student is required to complete the budget assignment using the template provided on the "Budget" tab of this file. 2 The cells with orange fill are where the data is to be entered. Formulas are required in ALL cells (no hard-coded numbers). Part of this assignment is assessing your ability to use Excel. The Data for these formulas is in the "Given" tab of this file. 3 formulas in any of the cells of one of the budgets, only 25% of the points possible will be awarded instead of the full 50% ). OPTIMA, INC. Additional information: Ending finished goods inventory (percentage of the next quarter's sales) Ending raw materials inventory (percentage of the next quarter's production) Expected number of frames sold in following quarters: Borrowing increments $1 $250,000 Quarterly dividend payments Regarding Inventory: Work-in-process has a zero beginning and ending balance. Direct Materials Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Purchased - Used = Ending) Finished Goods Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Produced - Sold = Ending)