Please provide Excell fomulas so I can compare what I've done. Thank you so much....
50.1K
Verified Solution
Link Copied!
Question
Accounting
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
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!