# PRODUCTION UNDER CONSTRAINTS_Goss Inc.

Question # 00005082 Posted By: ACCOUNTS_GURU Updated on: 12/10/2013 02:50 AM Due on: 12/31/2014
Subject Accounting Topic Accounting Tutorials:
Question
Goss Inc. has the capability to manufacture five products, and has 1,500 labor hours available each week for production. Each unit manufactured requires a
stamp of approval by an inspector, who works 40 hours per week and can inspect a unit in about a minute. Per-unit information about the five products is as follows:

Selling Price DM Cost Production Time Demand
Product A Selling Price\$50 DM Cost\$10 Production Time 1 hour Demand 350
Product B Selling Price\$35 DM Cost\$15 Production Time 1/2 hour Demand 350
Product C Selling Price\$70 DM Cost \$20 Production Time 2 hours Demand 500
Product D Selling Price \$100 DM Cost \$30 Production Time 3 1/2 hours Demand 250
Product E Selling Price\$20 DM Cost \$5 Production Time 1/4 hour Demand 300

Currently, Goss only produces its two highest throughput margin products, manufacturing 312 units of Product C and 250 units of Product D each week. Goss cannot change its production capacity, but it could hire an additional inspector if needed for \$500 per week.
Determine whether Goss is using its production capacity wisely, and if that capacity could or should be increased. Determine the optimum product mix given current production constraints, and given production constraints if changes are made.

USE EXCEL TO ANSWER THIS. SHOW YOUR WORK BY INSERTING THE FORMULAS IN THE EXCEL WORKSHEET TO PRODUCE THE ANSWER.
Tutorials for this Question
1. ## Solution: PRODUCTION UNDER CONSTRAINTS_Goss Inc.

Tutorial # 00004872 Posted By: ACCOUNTS_GURU Posted on: 12/10/2013 02:51 AM
Puchased By: 2
Tutorial Preview
The solution of PRODUCTION UNDER CONSTRAINTS_Goss Inc....
Attachments
PRODUCTION_UNDER_CONSTRAINTS_Goss_Inc._.xlsx (10.37 KB)

Great! We have found the solution of this question!