Please provide Excell fomulas so I can compare what I've done. Thank you so much....

50.1K

Verified Solution

Question

Accounting

imageimagePlease 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!
Become a Member

Other questions asked by students