Please provide Excell fomulas so I can compare what I've done. Thank you so much.
November Budget Data Input Quantities per Unit of Output Catillac erati Plastic (DM) Direct labor Machine time 3 pounds 3 hours 5 pounds 5 hours 20 hours 13 hours Direct Input Prices Plastic Direct labor $4 per pound $14 per hour Manufacturing Overhead Cost Pools and Rates Setup Processing Inspection $125 per setup hour $5 per machine hour $20 per inspection hour Additional Cost Driver Data Catillac 25 1.2 hours 0.5 hour erati Number of units per batch Setup time per batch Inspection time per batch 15 1.8 hours 0.6 hour Direct Materials Inventory Information Beginning inventory Cost of beginning inventory Target ending inventory 230 pounds $874 400 pounds 50% of purchases are paid for in the month of purchase: 50% the following month October materials purchases totaled $13,800 Sales and Finished Goods Inventory Information* Expected sales (units) Selling price Beginning inventory (units) Cost of beginning inventory Target ending inventory (units) Catillac 580 $175 25 $3,000 45 erati 240 $275 40 $7,600 25 96% of sales are credit card sales, for which the bank deducts a 2% processing fee The other 4% are cash sales Operating Expenses Marketing and administrative $14,600 per monthbank fees (see related bullet above) Sales commissions Shipping 1% of sales revenue $10 per unit shipped All inventories, both materials and finished goods, are accounted for using a FIFO cost flow assumption. November Budget Data Input Quantities per Unit of Output Catillac erati Plastic (DM) Direct labor Machine time 3 pounds 3 hours 5 pounds 5 hours 20 hours 13 hours Direct Input Prices Plastic Direct labor $4 per pound $14 per hour Manufacturing Overhead Cost Pools and Rates Setup Processing Inspection $125 per setup hour $5 per machine hour $20 per inspection hour Additional Cost Driver Data Catillac 25 1.2 hours 0.5 hour erati Number of units per batch Setup time per batch Inspection time per batch 15 1.8 hours 0.6 hour Direct Materials Inventory Information Beginning inventory Cost of beginning inventory Target ending inventory 230 pounds $874 400 pounds 50% of purchases are paid for in the month of purchase: 50% the following month October materials purchases totaled $13,800 Sales and Finished Goods Inventory Information* Expected sales (units) Selling price Beginning inventory (units) Cost of beginning inventory Target ending inventory (units) Catillac 580 $175 25 $3,000 45 erati 240 $275 40 $7,600 25 96% of sales are credit card sales, for which the bank deducts a 2% processing fee The other 4% are cash sales Operating Expenses Marketing and administrative $14,600 per monthbank fees (see related bullet above) Sales commissions Shipping 1% of sales revenue $10 per unit shipped All inventories, both materials and finished goods, are accounted for using a FIFO cost flow assumption
