Business, 10.03.2020 00:49 carter4026

Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the same production equipment, and the objective is to meet the demands for the three products using overtime where necessary. The demand forecast for the next four months, in hours required to make each product, is:

PRODUCT APRIL MAY JUNE JULY
A 760 560 760 1,160
B 560 660 860 1,090
C 660 460 660 810

Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carrying cost when a product is made and carried in inventory to meet future demand. Each hour's production carried into future months costs $3 per production hour for A, $4 for Model B, and $5 for Model C.

Production can take place either during regular working hours or during overtime. Regular time is paid at $4 when working on A, $5 for B, and $6 for C. The overtime premium is 50 percent of the regular time cost per hour.
The number of production hours available for regular time and overtime is:

APRIL MAY JUNE JULY
Regular time 1,460 1,310 1,760 1,970
Overtime 660 610 860 980

Required:
Calculate the objective value using Excel Solver.

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 14:20

Jaynet spends $50,000 per year on painting supplies and storage space. she recently received two job offers from a famous marketing firm – one offer was for $95,000 per year, and the other was for $120,000. however, she turned both jobs down to continue a painting career. if jaynet sells 35 paintings per year at a price of $6,000 each: a. what are her accounting profits? b. what are her economic profits?

Answers: 1

Answer

Business, 22.06.2019 14:30

Bridge building company estimates that it will incur $1,200,000 in overhead costs for the year. additionally, the company estimates 50,000 direct labor hours will be spent building custom walking bridges for the year at a total direct labor cost of $600,000. what is the predetermined overhead rate for bridge building company if direct labor costs are to be used as an allocation base?

Answers: 3

Answer

Business, 22.06.2019 18:00

Acountry made education free in mandatory up to age 15. it is established 100 new schools to educate kids across the country. as a result, citizens acquired the _ required to work. the school's generated _ for teachers and other staff. in 20 years, to countryside rapid _ and its gdp.

Answers: 3

Answer

Business, 22.06.2019 21:00

Haley photocopying purchases a paper from an out-of-state vendor. average weekly demand for paper is 150 cartons per week for which haley pays $15 per carton. in bound shipments from the vendor average 1000 cartoons with an average lead time of 3 weeks. haley operates 52 weeks per year; it carries a 4-week supply of inventory as safety stock and no anticipation inventory. the vendor has recently announced that they will be building a faculty near haley photocopying that will reduce lead time to one week. further, they will be able to reduce shipments to 200 cartons. haley believes that they will be able to reduce safety stock to a 1-week supply. what impact will these changes make to haley’s average inventory level and its average aggregated inventory value?

Answers: 1

Answer

You know the right answer?

Alan Industries is expanding its product line to include three new products: A, B, and C. These are...

Questions