How do you solve ch.11 problem 9? The Restwell Motel in Orlando, Florida, is preparing an...

How do you solve ch.11 problem 9?

The Restwell Motel in Orlando, Florida, is preparing an aggregate plan for the upcoming twelve days. The motel has a maximum of 200 rooms, but demand varies during the week. Demand is listed in terms of rooms rented each day. The motel requires one employee, paid $105 per day for each 12 rooms rented on regular time. It can utilize up to 20 percent overtime at time and a half and also can hire part-time workers at $120 per day. Each part-time worker can also clean 12 rooms per day. There is no hiring and layoff cost for the part-time workers. A fractional number of part-time workers (e.g., 3.4 workers) can be employed since less than a full day of employment is possible for each worker.

Day M T W Th F S Su M T W Th F

Demand 185 190 170 160 110 100 100 160 180 170 150 100

a. Assume a steady regular workforce of 10 employees, 20 percent overtime when needed, and the balance of demand met by part-time workers. How much does this strategy cost over the 12-day planning horizon. When needed to meet demand, assume maximum overtime is used before part-time workers are hired.

b. What is the total cost over the 12-day planning horizon if the regular workforce of 10 employees and only part-time workers are used? No overtime is used?

Solutions

Expert Solution

a) Aggregate plan based on steady regular workforce + Overtime + part time workers is as follows:

EXCEL FORMULAS :

Note : Continued table is given table.

Total cost with Full time and part-time employees = 16650 (Without considering Overtime )

Formula used :

NOTE : I hope you are happy with my answer

* Please help me with your rating *

THANK YOU

orchestra answered 1 year ago

Next > < Previous

Related Solutions

How do you solve Ch 14 Mini Case in Financial Management: Theory and Practice ? Integrated...

How do you solve Ch 14 Mini Case in Financial Management: Theory and Practice ? Integrated Waveguide Technologies (IWT) is a 6-year-old company founded by Hunt Jackson and David Smithfield to exploit metamaterial plasmonic technology to develop and manufacture miniature microwave frequency directional transmitters and receivers for use in mobile Internet and communications applications. IWT’s technology, although highly advanced, is relatively inexpensive to implement, and its patented manufacturing techniques require little capital as compared to many electronics fabrication ventures. Because...

Background You are the owner of AAA Landscaping, a small company in Orlando, Florida, that specializes...

Background You are the owner of AAA Landscaping, a small company in Orlando, Florida, that specializes in resodding and maintenance of lawns. Much of your business is through word-of-mouth advertising. Once a contract is negotiated, portions of it are subcontracted out to other companies (e.g., sprinkler system repair and pesticide services). Recently, you went to the home of Stu Murphy to bid on resodding his lawn. He obtained several other bids, but yours was the lowest. You arranged for work...

How do we solve the problem of the federal budget? Do you think you can do...

How do we solve the problem of the federal budget? Do you think you can do better than our lawmakers in Washington? Why is it so complicated? Here's your chance to take a crack at it. Use the budget simulator below to try to balance the federal budget, or at least bring it under control. Now, before you even get started, you must seriously think about a couple of things: you can't just cut programs you don't like, without thinking...

Problem #2: Orlando Corporation is preparing the financial statements for the annual report to its shareholders...

Problem #2: Orlando Corporation is preparing the financial statements for the annual report to its shareholders for the fiscal year ended August 31, 2017. The income from operations for fiscal year 2017 was $1,250,000. The company incurred a 6% interest expense on $3,000,000 of debt, an obligation outstanding for the entire fiscal year that requires interest-only payments. The company uses a 40% effective tax rate for income taxes. The capital structure of Orlando Corporation on September 1, 2016, at the...

Urgent! How do you do solve a knapsack problem recursively in JAVA. for an arbitrary knapsack...

Urgent! How do you do solve a knapsack problem recursively in JAVA. for an arbitrary knapsack capacity and series of weights. Assume the weights are sorted in an array. **The arguments to the knapsack function are target weight and the array index where the remaining items start. For example if you want your knapsack to weigh exactly 20 pounds and you have five items with weights of 11,8,7,6 and 5 pounds. In this case only combination that works is 8,...

You own a lot in Orlando, Florida that is currently unused. Similar lots have recently sold...

You own a lot in Orlando, Florida that is currently unused. Similar lots have recently sold for $1 million. Over the past five years, the price of land in the area has increased 6 percent per year, with an annual standard deviation of 10 percent. A buyer has recently approached you and wants an option to buy the land in the next 12 months for $1.05 million. The risk-free rate of interest is 3.5 percent per year, compounded continuously. How...

How would you handle this situation? What would you advise Orlando to do in this meeting?...

How would you handle this situation? What would you advise Orlando to do in this meeting? What would you tell his manager, if anything? Are there any systemic changes you could think of that may help prevent instances like these from happening in the future? The annual reviews have just been completed, and you heard from Orlando Nicholson, an employee who had been with the firm for two years. Orlando has a cordial but distant relationship with his manager. He...

Question