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
A company must meet (on time) the following demands: quarter 1 -30 units; quarter 2—20 units;...
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 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...
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...
The Austin, Texas plant of Computer Products produces disk units for personal and small business computers. Gerald Knox, the plant’s production planning director, is looking over next year’s sales forecasts for these products and will be developing an aggregate capacity plan for the plant. The quarterly sales forecasts for the disk units are as follows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 2,310 1,980 1,980 2,340 Ample machine capacity exists to produce the forecast. Each disk unit takes an...
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...
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. 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...
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 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...
For Gundy Company, units to be produced are 5,570 in quarter 1 and 6,600 in quarter 2. It takes 1.5 hours to make a finished unit, and the expected hourly wage rate is $16 per hour. Prepare a direct labor budget by quarters for the 6 months ending June 30, 2020 GUNDY COMPANY Direct Labor Budget Quarter Six Months