Business
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.

answer
Answers: 2

Other questions on the subject: Business

image
Business, 21.06.2019 19:30, jachecj3269
The framers of the us constitution created a system of government that established branches of government set forth the powers of such a branches and placed limits on those powers what are the benefits of such a system? are there any problems associated with such a system?
Answers: 3
image
Business, 22.06.2019 02:00, bannedccnt
Ida sidha karya company is a family-owned company located on the island of bali in indonesia. the company produces a handcrafted balinese musical instrument called a gamelan that is similar to a xylophone. the gamelans are sold for $860. selected data for the company’s operations last year follow: units in beginning inventory 0 units produced 320 units sold 285 units in ending inventory 35 variable costs per unit: direct materials $ 135 direct labor $ 355 variable manufacturing overhead $ 30 variable selling and administrative $ 15 fixed costs: fixed manufacturing overhead $ 64,000 fixed selling and administrative $ 27,000 the absorption costing income statement prepared by the company’s accountant for last year appears below: sales $ 245,100 cost of goods sold 205,200 gross margin 39,900 selling and administrative expense 31,275 net operating income $ 8,625 required: 1. under absorption costing, how much fixed manufacturing overhead cost is included in the company's inventory at the end of last year? 2. prepare an income statement for last year using variable costing. what is the amount of the difference in net operating income between the two costing methods?
Answers: 1
image
Business, 22.06.2019 08:30, isaicruz2018
Which actions can you improve your credit score? (multiple can be selected)having a good credit score should be your prime objective as credit companies analyze your creditworthiness before giving you a loan. there are certain guidelines you can follow to ensure you have a good credit score. always pay your mortgage interest on time. if you are a student, make student loan inquiries before taking any loan. if you have multiple credit cards, manage them judiciously. maintain a healthy balance in your bank account.1. always pay your mortgage interest on time.2. if you are a student, make student loan inquiries before taking any loan.3. if you have multiple credit cards, manage them judiciously.4. maintain a healthy balance in your bank account.
Answers: 1
image
Business, 22.06.2019 09:30, byron17
Oliver's company is planning the launch of their hybrid cars. the company has included "never-before-seen" product benefits in the hybrid cars. which type of advertising should oliver's company use for the new cars?
Answers: 1
Do you know the correct answer?
Alan Industries is expanding its product line to include three new products: A, B, and C. These are...

Questions in other subjects:

Konu
Chemistry, 19.03.2021 18:50
Konu
Chemistry, 19.03.2021 18:50
Konu
History, 19.03.2021 18:50
Konu
English, 19.03.2021 18:50
Konu
Chemistry, 19.03.2021 18:50