Find the Finished Goods Inventory Cost per unit

Excel File Edit View Insert Format Tools Data Window Help 59% E, Tue Apr 2 1:39 PM Q i ACCT 285 Excel Project Template -Spring 2019 Search Sheet Home Insert Page Layout FormulasData Review View + Share Insert Delete Format Calibri (Body) 12 , A-A | Wrap Text General ,3, A, EDE It, Merge & Center, $, % , 1.00 Conditional Format Cell Styles Sort & Formatting as Table S 15 A B Spring 2019 Excel Spreadsheet Project INPUTS Robert Hart Name: PROJECTED BUDGETING DATA ChocoLasting Chocolate Company Balance Sheet As of September 30, 2019 2019 2020 October November December January February Sales: Sales in Units Sen Price per Unit ASSETS LIABILITIES &EQUITIES $28,200 100,0 130,000Atcounts Payable Collectlons: Collected in the Month af Sale Collected in Following Month Accounts Receiwable Raw Materias Inventory inished Gcods Inventory $31,600 Notes Payable 21,600Interest Payable $17,550 190,000 Common Stock 13 TOTAL LIABILITIES 12B,2 Retained Earnin TOTAL EQUITIES TOTAL LIABILITIES& EQUITIES $182,550 $262,55 5390,750 15 Finished Goods Inventory: Ending FG Inventory Requirement 16 of next month's unit sales TOTALASSETS 5390,750 19 Beinning FG Inventory, October 1, 2019 21- Beginning RM Inventory, October 1,2019 Raw Materials Required per Unit of FG 8 pounds $0.75 per pound 23 Raw Materials Cost per Pound 24 Ending RM Inventory Requirement 25 26 27 of next month's production needs Paid in Month of Purchase aid in Following Month INPUTS FG Inventory Cost per Unit Sales Budget Expected Cash Collections Production Budget RM Budget DL Budget OH Budget S&A Budget Cash Budget Inco me + Ready + 100% Finished Goods Inventory Cost per Unit Per Unit Direct Material Direct Labor Variable Overhead TOTAL FG INVENTORY COST PER UNIT Note: Computing the cost of a unit of inventory will be useful later on when you have to do a budgeted income statement & budgeted balance sheet. Excel File Edit View Insert Format Tools Data Window Help 59% E, Tue Apr 2 1:39 PM Q i ACCT 285 Excel Project Template -Spring 2019 Search Sheet Home Insert Page Layout FormulasData Review View + Share Insert Delete Format Calibri (Body) 12 , A-A | Wrap Text General ,3, A, EDE It, Merge & Center, $, % , 1.00 Conditional Format Cell Styles Sort & Formatting as Table S 15 A B Spring 2019 Excel Spreadsheet Project INPUTS Robert Hart Name: PROJECTED BUDGETING DATA ChocoLasting Chocolate Company Balance Sheet As of September 30, 2019 2019 2020 October November December January February Sales: Sales in Units Sen Price per Unit ASSETS LIABILITIES &EQUITIES $28,200 100,0 130,000Atcounts Payable Collectlons: Collected in the Month af Sale Collected in Following Month Accounts Receiwable Raw Materias Inventory inished Gcods Inventory $31,600 Notes Payable 21,600Interest Payable $17,550 190,000 Common Stock 13 TOTAL LIABILITIES 12B,2 Retained Earnin TOTAL EQUITIES TOTAL LIABILITIES& EQUITIES $182,550 $262,55 5390,750 15 Finished Goods Inventory: Ending FG Inventory Requirement 16 of next month's unit sales TOTALASSETS 5390,750 19 Beinning FG Inventory, October 1, 2019 21- Beginning RM Inventory, October 1,2019 Raw Materials Required per Unit of FG 8 pounds $0.75 per pound 23 Raw Materials Cost per Pound 24 Ending RM Inventory Requirement 25 26 27 of next month's production needs Paid in Month of Purchase aid in Following Month INPUTS FG Inventory Cost per Unit Sales Budget Expected Cash Collections Production Budget RM Budget DL Budget OH Budget S&A Budget Cash Budget Inco me + Ready + 100% Finished Goods Inventory Cost per Unit Per Unit Direct Material Direct Labor Variable Overhead TOTAL FG INVENTORY COST PER UNIT Note: Computing the cost of a unit of inventory will be useful later on when you have to do a budgeted income statement & budgeted balance sheet