03 Jan Set of 3 Problems for excel – Operations Mg mt Class
Set of 3 Problems for excel – Operations Mg mt Class
Details:Complete problems 1.1, 1.9, and 1.13 in the textbook. (Problems are highlighted)
Submit one Excel file. Put each problem result on a separate sheet in your file.
1.1 Chuck Sox makes wooden boxes in which to ship motorcycles. Chuck and his three employees invest a total of 40
hours per day making the 120 boxes.
a) What is their productivity?
b) Chuck and his employees have discussed redesigning the process
to improve efficiency. If they can increase the rate to 125
per day, what will be their new productivity?
c) What will be their unit increase in productivity per hour?
d) What will be their percentage change in productivity?
1.9 Lillian Fok is president of Lakefront Manufacturing,
a producer of bicycle tires. Fok makes 1,000 tires per day with the
Labor: 400 hours per day @ $12.50 per hour
Raw material: 20,000 pounds per day @ $1 per pound
Energy: $5,000 per day
Capital costs: $10,000 per day
a)What is the labor productivity per labor-hour for these tires at
b) What is the multifactor productivity for these tires at
c) What is the percent change in multifactor productivity if Fok
can reduce the energy bill by $1,000 per day without cutting
production or changing any other inputs?
1.13 Charles Lackey operates a bakery in Idaho Falls, Idaho.
Because of its excellent product and excellent location, demand has
increased by 25% in the last year. On far too many occasions, customers
have not been able to purchase the bread of their choice.
Because of the size of the store, no new ovens can be added. At a
staff meeting, one employee suggested ways to load the ovens differently
so that more loaves of bread can be baked at one time. This
new process will require that the ovens be loaded by hand, requiring
additional manpower. This is the only thing to be changed. If the
bakery makes 1,500 loaves per month with a labor productivity of
2.344 loaves per labor-hour, how many workers will Lackey need to
add? (Hint: Each worker works 160 hours per month.)
HOW OUR WEBSITE WORKS
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of
HIGH QUALITY & PLAGIARISM FREE.
To make an Order you only need to click ORDER NOW and we will direct you to our Order Page at WriteDen. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Deadline range from 6 hours to 30 days.
Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email.
Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost.
Is it Safe to use our services?
We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper.
Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.
Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you.