Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer on excel Cost Information Inventory carrying cost + Subcontracting cost per unit Average pay rate per hour Average pay rate per day Overtime

please answer on excel image text in transcribed
Cost Information Inventory carrying cost + Subcontracting cost per unit Average pay rate per hour Average pay rate per day Overtime pay rate Labor-hours to produce a unit $ $ $ $ $ 3. per unit per month 20 per unit 10 per hour 80 per day 17 $17 per hour (above 8 hours per day) 4.0 4 hours per unit One employee daily production ?? units per emplyee Monthly Forecasts MONTH EXPECTED DEMAND PRODUCTION DAYS Jan 800 21 Feb 500 18 Mar 600 18 Apr 1,050 22 May 1.150 19 June 1,100 20 5,200 118 Plan 2 (constant workforce by meeting the lowest demand per day month + Sub-contracting) In House daily production = ?? unit per day Total Units Produced in house ?? Units Subcotract Units units Number of Regular Employees ?? Regular Time Employee Total regular employees costs ?? Total Subcontracting Cost ?? Total Cost ?? Cost Information Inventory carrying cost + Subcontracting cost per unit Average pay rate per hour Average pay rate per day Overtime pay rate Labor-hours to produce a unit $ $ $ $ $ 3. per unit per month 20 per unit 10 per hour 80 per day 17 $17 per hour (above 8 hours per day) 4.0 4 hours per unit One employee daily production ?? units per emplyee Monthly Forecasts MONTH EXPECTED DEMAND PRODUCTION DAYS Jan 800 21 Feb 500 18 Mar 600 18 Apr 1,050 22 May 1.150 19 June 1,100 20 5,200 118 Plan 2 (constant workforce by meeting the lowest demand per day month + Sub-contracting) In House daily production = ?? unit per day Total Units Produced in house ?? Units Subcotract Units units Number of Regular Employees ?? Regular Time Employee Total regular employees costs ?? Total Subcontracting Cost ?? Total Cost

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fair Value Measurement Practical Guidance And Implementation

Authors: Mark L. Zyla

3rd Edition

1119191238, 9781119191230

More Books

Students also viewed these Accounting questions

Question

What are their resources?

Answered: 1 week ago