Homework Answers
- Solution:
|
Month |
Demand |
Workforce |
Labor-Hour/Disk |
Disk Produced in Day |
Beginning Inventory |
Workdays/Month |
Regular Wages |
Overtime |
Hiring Cost |
Layoff Cost |
Productivity per Month |
Product End of Month |
Total Cost of Labors |
|
Jul |
400 |
8 |
4 |
2 |
150 |
20 |
12 |
18 |
4000 |
8000 |
320 |
470 |
15360 |
|
Aug |
500 |
11 |
4 |
2 |
70 |
20 |
12 |
18 |
4000 |
8000 |
440 |
510 |
1941120 |
|
Sep |
550 |
14 |
4 |
2 |
10 |
20 |
12 |
18 |
4000 |
8000 |
560 |
570 |
3866880 |
|
Oct |
700 |
18 |
4 |
2 |
20 |
20 |
12 |
18 |
4000 |
8000 |
720 |
740 |
6434560 |
|
Nov |
800 |
20 |
4 |
2 |
40 |
20 |
12 |
18 |
4000 |
8000 |
800 |
840 |
7718400 |
|
Dec |
700 |
17 |
4 |
2 |
40 |
20 |
12 |
18 |
4000 |
8000 |
680 |
720 |
5792640 |
Copy Paste Excel Formula Sheet in Cell A1: [Note – This is the solution, yet if you want change the workforce column and the corresponding values changes]
|
Month |
Demand |
Workforce |
Labor-Hour/Disk |
Disk Produced in Day |
Beginning Inventory |
Workdays/Month |
Regular Wages |
Overtime |
Hiring Cost |
Layoff Cost |
Productivity per Month |
Product End of Month |
Total Cost of Labors |
|
Jul |
400 |
8 |
4 |
=8/D2 |
150 |
20 |
12 |
18 |
4000 |
8000 |
=C2*E2*G2 |
=L2+F2 |
=((C2*H2)+(C2-8)*J2)*8*G2 |
|
Aug |
500 |
11 |
4 |
=8/D3 |
=M2-B2 |
20 |
12 |
18 |
4000 |
8000 |
=C3*E3*G3 |
=L3+F3 |
=((C3*H3)+(C3-8)*J3)*8*G3 |
|
Sep |
550 |
14 |
4 |
=8/D4 |
=M3-B3 |
20 |
12 |
18 |
4000 |
8000 |
=C4*E4*G4 |
=L4+F4 |
=((C4*H4)+(C4-8)*J4)*8*G4 |
|
Oct |
700 |
18 |
4 |
=8/D5 |
=M4-B4 |
20 |
12 |
18 |
4000 |
8000 |
=C5*E5*G5 |
=L5+F5 |
=((C5*H5)+(C5-8)*J5)*8*G5 |
|
Nov |
800 |
20 |
4 |
=8/D6 |
=M5-B5 |
20 |
12 |
18 |
4000 |
8000 |
=C6*E6*G6 |
=L6+F6 |
=((C6*H6)+(C6-8)*J6)*8*G6 |
|
Dec |
700 |
17 |
4 |
=8/D7 |
=M6-B6 |
20 |
12 |
18 |
4000 |
8000 |
=C7*E7*G7 |
=L7+F7 |
=((C7*H7)+(C7-8)*J7)*8*G7 |
- Solution:
|
Month |
Demand |
Workforce |
Labor-Hour/Disk |
Disk Produced in Day |
Beginning Inventory |
Workdays/Month |
Regular Wages |
Overtime |
Subcontracting Cost/ Disk |
Productivity per Month |
Product End of Month |
Additional Demand |
Cost of Subcontracting |
|
Jul |
400 |
8 |
4 |
2 |
150 |
20 |
12 |
18 |
80 |
320 |
470 |
-70 |
0 |
|
Aug |
500 |
8 |
4 |
2 |
70 |
20 |
12 |
18 |
80 |
320 |
390 |
110 |
8800 |
|
Sep |
550 |
8 |
4 |
2 |
-110 |
20 |
12 |
18 |
80 |
320 |
210 |
340 |
27200 |
|
Oct |
700 |
8 |
4 |
2 |
-340 |
20 |
12 |
18 |
80 |
320 |
-20 |
720 |
57600 |
|
Nov |
800 |
8 |
4 |
2 |
-720 |
20 |
12 |
18 |
80 |
320 |
-400 |
1200 |
96000 |
|
Dec |
700 |
8 |
4 |
2 |
-1200 |
20 |
12 |
18 |
80 |
320 |
-880 |
1580 |
126400 |
Copy Paste Excel Formula Sheet in Cell A1: [Note – This is the solution, yet if you want change the any column and the corresponding values changes]
|
Month |
Demand |
Workforce |
Labor-Hour/Disk |
Disk Produced in Day |
Beginning Inventory |
Workdays/Month |
Regular Wages |
Overtime |
Subcontracting Cost/ Disk |
Productivity per Month |
Product End of Month |
Additional Demand |
Cost of Subcontracting |
|
Jul |
400 |
8 |
4 |
=8/D2 |
150 |
20 |
12 |
18 |
80 |
=C2*E2*G2 |
=K2+F2 |
=B2-L2 |
0 |
|
Aug |
500 |
8 |
4 |
=8/D3 |
=L2-B2 |
20 |
12 |
18 |
80 |
=C3*E3*G3 |
=K3+F3 |
=B3-L3 |
=M3*J3 |
|
Sep |
550 |
8 |
4 |
=8/D4 |
=L3-B3 |
20 |
12 |
18 |
80 |
=C4*E4*G4 |
=K4+F4 |
=B4-L4 |
=M4*J4 |
|
Oct |
700 |
8 |
4 |
=8/D5 |
=L4-B4 |
20 |
12 |
18 |
80 |
=C5*E5*G5 |
=K5+F5 |
=B5-L5 |
=M5*J5 |
|
Nov |
800 |
8 |
4 |
=8/D6 |
=L5-B5 |
20 |
12 |
18 |
80 |
=C6*E6*G6 |
=K6+F6 |
=B6-L6 |
=M6*J6 |
|
Dec |
700 |
8 |
4 |
=8/D7 |
=L6-B6 |
20 |
12 |
18 |
80 |
=C7*E7*G7 |
=K7+F7 |
=B7-L7 |
=M7*J7 |
Excel Sheet for Reference:
Add Answer to:
02 Consuelo Chua, Inc., is a disk drive manufacturer in need of an aggregate plan for...
Consuelo Chua, Inc., is a disk drive manufacturer in need of an aggregate plan for July...
Consuelo Chua, Inc., is a disk drive manufacturer in need of an aggregate plan for July through December. The company has gathered the following data given in the tables. There are 8 hours of production per day. You manage a consulting firm down the street from Consuelo Chua, Inc., and to get your foot in the door, you have told Mr. Chua that you can do a better job at aggregate planning than his current staff. He said, "Fine. You...
Consuelo Chua, Inc., is a disk drive manufacturer in need of an aggregate plan for July...
Consuelo Chua, Inc., is a disk drive manufacturer in need of an aggregate plan for July through December. The company has gathered the following data given in the tables. There are 8 hours of production per day. You manage a consulting firm down the street from Consuelo Chua, Inc., and to get your foot in the door, you have told Mr. Chua that you can do a better job at aggregate planning than his current staff. He said, "Fine. You...
A disk drive manufacturer is in need of an aggregate plan for July to December. The...
A disk drive manufacturer is in need of an aggregate plan for July to December. The company has gathered the following data: Month Demand Month Demand July 400 Oct 700 Aug 500 Nov 800 Sep 550 Dec 700 Item Cost Materials $35/disk Inventory $8/disk/month Subcontracting $80/disk Stock-out $15/disk Regular time labor $12/hour Overtime labor $18/hour (above 8 hrs) Hiring cost $40/worker Layoff cost $80/worker Other data include: Item Data Current workforce (June) 8 people Labor hours per disk 4 hrs...
AGGREGATE PLANNING Garden Hub makes a single product, a garden tool that sells for $40. Garden Hub starts with 1000 of these tools in inventory and is expected to end with at least 500 in stock. Garde...
AGGREGATE PLANNING
Garden Hub makes a single product, a garden tool that sells for
$40. Garden Hub starts with 1000 of these tools in inventory and is
expected to end with at least 500 in stock. Garden Hub can
temporarily backlog demand for a cost, but at the end of the time
horizon, they require their backlog to be zero – This is an
important constraint to remember- if we forget it, we will get
strange results . Production costs...
Need help filling the empty slots above in. What is Plan A's cost = ___?(enter response...
Need help filling the empty slots above in.
What is Plan A's cost = ___?(enter response as a whole
number)
Refrigeration Corp. needs an aggregate plan for January through June for its refrigerator production. The company has developed the following data: B Click the icon to view the company's data. Consider the two following strategies. a) Plan A: Vary the workforce so that production meets the forecasted demand (maintain inventory at 250 units). Bell had eight employees on staff in...
USE LEVEL AGGREGATE PLAN: Cost data Regular time labor cost per hour $10 Overtime time labor...
USE LEVEL AGGREGATE PLAN: Cost data Regular time labor cost per hour $10 Overtime time labor cost per hour $15 Subcontracting cost per unit $80 Back order cost per unit per period $20 Inventory holding cost per unit per period $10 Hiring cost per employee $400 Firing cost per employee $500 Capacity data Beginning workforce 40 employees Beginning inventory 0 units Beginning backorders 0 units Production standard per unit (hours) 2 hours of labor per unit Regular time available per...
Problem 8-8 Plan production for a four-month period: February through May. For February and March, you...
Problem 8-8 Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply,...
Plan production for a four-month period: February through May. For February and March, you should produce...
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders...
The Barberton Municipal division of Road Maintenance is charged with road repair in the city of B...
The Barberton Municipal division of Road Maintenance is charged with road repair in the city of Barberton and the sumounding area. Cindy Kramer, road maintenance director, must submit a staffing plan for Kramer estimates that the labor hours required for the next four quarters are 6,000, 12.000. 20,000, and 9.000 the 11 workers on the workforce can contribute 500 hours per quarter. Payroll costs are $6,000 in wages per worker for regular time worked up to 500 hours, with an...
Plan production for a four-month period: February through May. For February and March, you should produce...
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders...
AGGREGATE PLANNING
Garden Hub makes a single product, a garden tool that sells for
$40. Garden Hub starts with 1000 of these tools in inventory and is
expected to end with at least 500 in stock. Garden Hub can
temporarily backlog demand for a cost, but at the end of the time
horizon, they require their backlog to be zero – This is an
important constraint to remember- if we forget it, we will get
strange results . Production costs...
Need help filling the empty slots above in.
What is Plan A's cost = ___?(enter response as a whole
number)
Refrigeration Corp. needs an aggregate plan for January through June for its refrigerator production. The company has developed the following data: B Click the icon to view the company's data. Consider the two following strategies. a) Plan A: Vary the workforce so that production meets the forecasted demand (maintain inventory at 250 units). Bell had eight employees on staff in...
Problem 8-8 Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply,...
The Barberton Municipal division of Road Maintenance is charged with road repair in the city of Barberton and the sumounding area. Cindy Kramer, road maintenance director, must submit a staffing plan for Kramer estimates that the labor hours required for the next four quarters are 6,000, 12.000. 20,000, and 9.000 the 11 workers on the workforce can contribute 500 hours per quarter. Payroll costs are $6,000 in wages per worker for regular time worked up to 500 hours, with an...
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders...
Most questions answered within 3 hours.
-
How does a leadership philosophy shape service delivery in a
human services organization?
asked 1 minute ago -
You roll a fair 6-sided dice, let Y be the outcome of the dice
roll. Then...
asked 3 minutes ago -
Which of the following statements about hormonal regulation of
glycogen synthesis and degradation are correct?
Multiple...
asked 6 minutes ago -
1. Describe all
necessary steps and conditions for execution of a java".
2. What
is maven...
asked 18 minutes ago -
Use C programe to :
Develop an algorithm, flow chart and write a C program to...
asked 8 minutes ago -
What is the temperature of a 3.5L container with 1.502 mol
carbon dioxide at 10.76 atm?...
asked 13 minutes ago -
A dragster makes a pass down a track in exactly 7.03 seconds.
You do not know,...
asked 18 minutes ago -
What evidence can you provide to illustrate why
crowdsourcing is able to reduce system development costs?...
asked 22 minutes ago -
If the value of the range is equal to zero, then this indicates
that:
A. there...
asked 23 minutes ago -
Hi, I was wondering if I could get some help on a java program
that I...
asked 28 minutes ago -
Given is the peptide Ala-Lys-Lys-Asp-Phe
1) what is the pI for this peptide? show your
calculations!...
asked 33 minutes ago -
Discuss the benefits of Inventory, Reservation,
& Menu Management Systems. Assuming you are the Manager for...
asked 38 minutes ago