Question

A company must meet (on time) the following demands: quarter 1 -30 units; quarter 2—20 units; quarter 3—40 units. Each quarte

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Choice Variables: Let's characterize them as follows

Xi = number of units that are delivered with normal time work during these 3 quarters, 1,2,3

Yi = number of units that are delivered with extra time work during these 3 quarters, 1,2,3

Zi = number of units that are held to starting with one quarter then onto the next quarter

\RightarrowTotal Cost = 40 Xi + 60 Yi + 15 Zi (i=1,2,3) ........ (1)

At most 27 units can be delivered with normal time work, Xi\leq 27 for i=1,2,3 .....(2)

To locate the quantity of usable units that are left by end of quarter 1, we have 20 units during the beginning of quarter 1, assume X1+Y1 are delivered and 80% are usable, and request is 30. Henceforth,

Z1 = 20 + 0.8 (X1+Y1) - 30 ....(3)

Additionally for quarter 2, number of usable units to begin will be Z1, X2 + Y2 are prdouced with 80% ease of use and request is 20,

Z2 = Z1 + 0.8 (X2 + Y2) - 20 ....(4)

for quarter 3, number of usable units to begin will be Z2, X3 + Y3 are prdouced with 80% ease of use and request is 40,

Z3 = Z2 + 0.8 (X3 + Y3) - 40 ....(5)

All factors should be non negative, thus

Xi, Yi, Zi\geq 0 for i=1,2,3 ... (6)

Consequently, the LP plan is

Limit 40 Xi + 60 Yi + 15 Zi (i=1,2,3

subject to Xi\leq 27 for i=1,2,3

Z1 = 20 + 0.8 (X1+Y1) - 30

Z2 = Z1 + 0.8 (X2 + Y2) - 20

Z3 = Z2 + 0.8 (X3 + Y3) - 40

Xi, Yi, Zi\geq 0 for i=1,2,3

Add a comment
Know the answer?
Add Answer to:
A company must meet (on time) the following demands: quarter 1 -30 units; quarter 2—20 units;...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • AA 40. Each year, a shoe manufacturing company faces demands (which must be met on time)...

    AA 40. Each year, a shoe manufacturing company faces demands (which must be met on time) for pairs of shoes as shown in the file P03_40.xlsx. Employees work three consecutive quarters and then receive one quarter off. For example, a worker might work during quarters 3 and 4 of one year and quarter 1 of the next year. During a quarter in which an employee works, he or she can produce up to 600 pairs of shoes. Each worker is...

  • Units to be produced 1st Quarter 12,000 2nd Quarter 15,000 3rd Quarter 14,000 4th Quarter 13,000...

    Units to be produced 1st Quarter 12,000 2nd Quarter 15,000 3rd Quarter 14,000 4th Quarter 13,000 In addition, 15,000 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $6,200. Each unit requires 5 grams of raw material that costs $1.80 per gram. Management desires to end each quarter with an inventory of raw materials equal to 25% of the following quarter's production needs. The...

  • Given the projected demands for the next six months, prepare an aggregate plan that uses inventor...

    Given the projected demands for the next six months, prepare an aggregate plan that uses inventory, regular time, overtime, subcontract and backorders. Regular time is limited to 150 units per month (Cost per Unit = $30 ). Overtime is limited to a maximum of 20 units per month (Cost per Unit -S45). Units purchased from the subcontractor (Cost per Unit = $54 ) cannot exceed 60 per month and the total purchases from the subcontractor over the 6 month period...

  • The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter fo...

    The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: Units to be produced 1st Quarter 7,000 2nd Quarter 10,000 3rd Quarter 9,000 4th Quarter 8,000 In addition, 8,750 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $5,200. Each unit requires 5 grams of raw material that costs $1.60 per...

  • I need the answer to include solver and excel. Thank you. A Company produces two products....

    I need the answer to include solver and excel. Thank you. A Company produces two products. Relevant information for each product is shown in the Table below. The company has a goal of $48 in profits and incurs $1 penalty for each dollar it falls short of this goal. A total of 32 hours of labor are available. A $2 penalty is incurred for each hour of overtime (labor over 32 hours) used, and $1 penalty is incurred for each...

  • The production department of Zan Corporation has submitted the following forecast of units to be produced...

    The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: Units to be produced e produced 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 7,000 10,000 9,000 8,000 In addition, 8,750 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $5,200. Each unit requires 5 grams of raw material that costs...

  • The production department of Zan Corporation has submitted the following forecast of units to be produced...

    The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 4th 1st Quarter 17,000 2nd Quarter 20,000 3rd Quarter 19,000 Units to be produced Quarter 18,000 In addition, 21,250 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $7,200. Each unit requires 5 grams of raw material that costs $1.20 per...

  • Assignment requirements: Hand in both a summary sheet with your answers, and the needed computer backup...

    Assignment requirements: Hand in both a summary sheet with your answers, and the needed computer backup work.    Put your name on all of the work; the computer output should have your name printed by the computer. (Include both a printout of your spreadsheet and a printout of the ANSWER report generated by SOLVER. Also if you could upload the excel sheet as well will be very appreciated. thanks Problem 4 Sailco Corporation must determine how many sailboats to produce during...

  • DUE SOON, PLEASE HELP!!!! Sales for the final quarter of the prior year total 800 units....

    DUE SOON, PLEASE HELP!!!! Sales for the final quarter of the prior year total 800 units. Expected sales in units) for the current year are: 720 (Quarter 1), 480 (Quarter 2), 640 (Quarter 3), and 640 (Quarter 4). Sales for the first quarter of the following year total 960 units. The selling price is $660 per unit in the first three quarters of the year, and $690 per unit in the final quarter. Company policy calls for a given quarter's...

  • DUE SOON, PLEASE HELP Sales for the final quarter of the prior year total 800 units....

    DUE SOON, PLEASE HELP Sales for the final quarter of the prior year total 800 units. Expected sales in units) for the current year are: 720 (Quarter 1), 480 (Quarter 2), 640 (Quarter 3), and 640 (Quarter 4). Sales for the first quarter of the following year total 960 units. The selling price is $660 per unit in the first three quarters of the year, and $690 per unit in the final quarter. Company policy calls for a given quarter's...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT