Question 16MONTHEXPECTED DEMANDPRODUCTION DAYSJan80021Feb50018Mar60018Apr105022May115019June110020Cost Information:Subcontracting cost = SR 17 per unit per monthAverage pay rate = SR 10 per hourLabor-hours to produce a unit = 4 hours per unitDaily working hours = 8 hoursa) Using excel, caleulate 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 tomeet all demand above this level by subcontracting. (Answer in Field )Attach your solutions.

Answered: a) Using excel, calculate the total…

Marketing

20th Edition

ISBN:9780357033791

Author:Pride, William M

Publisher:Pride, William M

Chapter19: Pricing Concepts

Section: Chapter Questions

Problem 6DRQ

See similar textbooks

Similar questions

Supply/Demand Info Predicted Sales Regular production Overtime production Subcontract production Ending inventory Hired employees Fired employees Total employees Cost variables are as follows: Cost Variables Labor cost/hour Overtime cost/ton Subcontracting costiton Holding cost ton/month Hiring cost employee Firing cost/employee Beginning Apr May 4,200 531 $20 $32 $25 $10 $3.700 $4.000 Jun 51,500 50.300 61,600 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/ton Regular production tons/employee/month Max regular production (tons/month) Max overtime production (tons/month) Max subcontractor production (tons/month) 3 100 56,700 3,700 6,000 Jul Aug Sep 45,400 56.600 62,800 Given the above information (and don't overlook beginning number of employees and inventory levels in the first table), create a LEVEL production plan with only the use of regular production and no inventory left over at the end of the six-month period. What is the regular…
OQ14
Please do not give solution in image formate thanku.
Q4) A manufacturer provides specialized microchips. During the next 3 months its sales, costs, and available time are shown in the table. Month 1 Month 2 Month 3 There are no chips in stock at the beginning of the first month. It takes 1.5 hr of production time to produce a chip and costs $5 to store a chip from one month to the next. Determine a production schedule that meets the demand requirements, does not exceed the monthly production time limitations, and minimizes cost. Note that no chips should be in stock at the end of the 3 months. Use fmincon. Chips required Cost regular time ($/chip) Cost overtime ($/chip) Regular operation time (hr) Overtime (hr) 1000 100 110 2500 100 120 2200 120 130 2400 2400 720 2400 720 720
Table 1. Demand of Hairdryer from January to July [Jadual 1. Permintaan Pengering Rambut dari Januari 2021 hingga Julai 2021] Month Demand January February 2800 2870 March 2968 April Мay 3000 3100 Jun 3150 July 3400 a) Calculate forecast future demand for May, June, July and August by using 3 months simple moving average.[hitung ramalan permintaan masa depan untuk bulan Mei, Jun, Julai dan Ogos dengan menggunakan purata bergerak sederhana 3 bulan.] *
a. Meaning of ABC analysis?
Q23 please help me I cannot figure these out all info is there that is needed
d) Cost of the fifth unit = ? (round your response to the nearaest whole number. (How do I find the calculation for this question?)
Consider the following price and dividend data for Ford Motor Company: Dividend ($) Date December 31, 2004 January 26, 2005 April 28, 2005 July 29, 2005 October 28, 2005 December 30, 2005 Price ($) $14.04 $13.43 $9.14 OA. -44.4% OB. -40.2% OC.-42.32% OD. -38.1% $10.74 $8.02 $7.72 $0.12 $0.12 $0.12 $0.12 Assume that you purchased Ford Motor Company stock at the closing price on December 31, 2004 and sold it at the closing price on December 30, 2005. Your realized annual return is for the year 2005 is closest to:
Break - Even Point in Units Chillmax Company plans to sell 3, 500 pairs of shoes at $60 each in the coming year. Unit variable cost is $21 (includes direct materials, direct labor, varlable factory overhead, and variable selling expense). Total fixed cost equals $78,000 (includes fixed factory overhead and fixed selling and administrative expense). Required: 1. Calculate the break-even pairs of shoes. 2. Check your answer by preparing a contribution margin income statement based on the break- even units. Enter all amounts as a positive number:
I need typing no chatgpt used
Q21 The owner of a large machine shop has just finished its financial analysis from the prior fiscal year. Following is an excerpt from the final report: Net revenue $ 348,000 Cost of goods sold 305,000 Value of production materials on-hand 42,500 Value of work-in-process inventory 67,000 Value of finished goods on-hand 27,500 a. Compute the inventory turnover ratio (ITR). (Round your answer to 1 decimal place.) b. Compute the weeks of supply (WS). (Do not round intermediate calculations. Round your answer to 1 decimal place.)

SEE MORE QUESTIONS

Recommended textbooks for you

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS

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 )