GOAL SEEK Raw Material Cost per Pound: Spring 2019 Excel Spreadsheet Project INPUTS 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 Selling Price per Unit ASSETS LIABILITIES & EQUITIES S28,2 $100,000 Cash Accounts Receivable Raw Materials Inventory Finished Goods Inv PP&E, net 0000Accounts Payable 3,600 Notes Payable Collections: Collected in the Month of Sale Collected in Following Month S21,600Interest Payable S17,550 Sl TOTAL LIABILITIES Common Stock Retained TOTAL EQUITIES $128,200 80,00 $182,55 $262,550 S390,75 $190,000 Finished Goods Inventory: Ending FG Inventory Requirement Beginning FG Inventory, October 1, 2019 of next month's unit sales TOTAL ASSETS S390,750 units Raw Materials Inventory: Beginning RM Inventory, October 1, 2019 Raw Materials Required per Unit of FG Raw Materials Cost per Pound Ending RM Inventory Requirement Paid in Month of Purchase Paid in Following Month pounds 8 pounds 0.75 per pound of next month's necds Direct Labor: Labor Required per Unit of FG Labor Cost per Hour hours per hour Manfacturing Overhead: Variable OH per labor hour ixed OH Noncash Fixed OH included in above) S 28,000 per month per month Selling & Administrative Expenses Variablc S&A Fixed S&A Noncash Fixed S&A (included in above per unit sold s 25,000 per month per month Cash Borrowings: Interest Payment Other: ent Purchase urchased on December 31, 2019