question archive MONTH EXPECTED DEMAND PRODUCTION DAYS Jan 800 21 Feb 500 18 Mar 600 18 Apr 1050 22 May 1150 19 June 1100 20 Cost Information: Subcontracting cost - SR 17 per unit per month Average pay rate - SR 10 per hour Labor hours to produce a unit 4 hours per unit Daily working hours - 8 hours a) Using excel calculate the total cost of the following plan: - Plan : is to maintain a constant workforce at a level necessary to meet the lowest demand month and to meet all demand above this level by subcontracting
MONTH EXPECTED DEMAND PRODUCTION DAYS Jan 800 21 Feb 500 18 Mar 600 18 Apr 1050 22 May 1150 19 June 1100 20 Cost Information: Subcontracting cost - SR 17 per unit per month Average pay rate - SR 10 per hour Labor hours to produce a unit 4 hours per unit Daily working hours - 8 hours a) Using excel calculate the total cost of the following plan: - Plan : is to maintain a constant workforce at a level necessary to meet the lowest demand month and to meet all demand above this level by subcontracting
Subject:AccountingPrice: Bought3
MONTH EXPECTED DEMAND PRODUCTION DAYS Jan 800 21 Feb 500 18 Mar 600 18 Apr 1050 22 May 1150 19 June 1100 20 Cost Information: Subcontracting cost - SR 17 per unit per month Average pay rate - SR 10 per hour Labor hours to produce a unit 4 hours per unit Daily working hours - 8 hours a) Using excel calculate the total cost of the following plan: - Plan : is to maintain a constant workforce at a level necessary to meet the lowest demand month and to meet all demand above this level by subcontracting.(Answer in Field) Attach your solutions.
