Blog
This must be completed in Excel using Excel Solver, and submitted in excel.
Ex. 5
We now reconsider the issue of competitors and promotions in the context of a commodity product such as detergent, for which demand is relatively stable during the year. Q&H is a major detergent manufacturer with a demand forecast for the coming year as shown in Table 9-6 (in tons).
Table 9-6 (in tons). The anticipated monthly demand for detergent at Q&H is
Month | Demand |
January | 280 |
February | 301 |
March | 277 |
April | 302 |
May | 285 |
June | 278 |
July | 291 |
August | 277 |
September | 304 |
October | 291 |
November | 302 |
December | 297 |
Capacity at Q&H is governed by the number of hours the line runs. The line requires a team of 100 employees. Employees are paid $10 per hour for regular time and $15 per hour for overtime. Each ton of detergent requires one hour of operation of the line. The plant works 20 days a month, two shifts a day, and eight hours a shift of regular time. Overtime is restricted to a maximum of 20 hours per employee per month.
Each ton of detergent uses $1,000 of material. Carrying a ton of detergent in inventory from one month to the next costs $100. Q&H starts with 150 tons in inventory and wants to end with the same level. During intermediate months, Q&H wants at least 100 tons of inventory. Detergent is currently sold to retailers for $2,600 per ton. The detergent market is shared between Q&H and its competitor, Unilock.
Q&H is in the process of making its production planning and promotion decisions. Q&H wants to consider only plans without any stockouts. One option is to drop the sale price by $260 per ton (from $2,600 to $2,340) for one month in the year. The outcome of this action by Q&H is influenced by the action taken by Unilock. If neither firm promotes, the forecast demand for Q&H is as shown in Table 9-6. If Q&H promotes in a given month but Unilock does not, Q&H sees consumption (does not include forward buying) in that month increase by 50 percent and forward buying of 20 percent from each of the two following months. If Unilock promotes in a given month but Q&H does not, Q&H sees consumption in the month drop by 50 percent. If both promote in a given month, neither sees an increase in consumption but both see forward buying of 25 percent from each of the two following months. The debate within Q&H is whether to promote, and if so, whether to do it in April or June. For the following questions, assume that demand for Unilock is like that of Q&H.
How it Works?
How it Works?
Step 1:- Want to buy solution for this. Please click on submit your assignment here and then fill all details and please mentioned product code at the end of the case. Product code is extremely important to locate your assignment. You can also mail us by keeping product code as mail subject to besthomewrokhelpers@gmail.com
Step 2:- As soon as we received your details, we will inform you with through email about quotations of the given assignment. Requesting you to please mention your budget. Also ensure our email besthomeworkhelpers@gmail.com should not go into your spam folder.
Step 3:- Once you agree with our price, click on pay now and pay the agreed amount and once we received the payment assignment will be delivered before agreed deadline.
Step 4:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.
Features
Our Features for Assignment Help Services
Plagiarism Free Solution
The first and foremost things that we promise to our customer is plagiarism free solution i.e. a complete and unique solution as per customer’s university requirements.
Excellent Customer Care Services
You can feel our responsiveness once you use our service. Our team of excellent and dedicated customer service representatives are always ready to provide best customer care service 24X7 . Just drop a mail to besthomeworkhelpers@gmail.com and you can receive response in just no time.
Multiple Stage Quality Assurance
We design a unique multiple stage quality assurance team to ensure plagiarism free, original, relevant and as per customer’s requirements. We not only give importance to accurate solutions or writing but also we give equal importance to references style too.
Privacy and Confidentiality
We believe in maintaining complete privacy and confidentiality of all our clients. None of the information furnished to us is shared with anyone else.
Our Clients
We receive requests from clients all over the World. Most of our customers are from USA, UK, Australia, Canada, UAE, Muscat, Oman, Qatar, UAE, New-Zealand, France Germany etc.
Related Services
- Accounting Homework Help
- Accounting Assignment Help
- Computer Science Homework Help
- Management Homework Help
- Finance Assignment Help
- Online Essay Writing Help
- Strategic management case study help
- Case Study Assignment Help
- Dissertation Writing Help
- Trade finance case study help
- Project Management Assignment Help
- Mechanical Engineering Homework Help
- Online Quiz Help
- Maths homework Help
- Online Exam Help
- Economics Assignment Help
- Economics Homework Help
- English Homework Help
- Macroeconomics Homework Help
- Microeconomics Homework Help
- Statistics Assignment Help
- Australia Taxation Homework Help
- Supply chain management homework help
- Taxation homework help
- USA taxation assignment help
- Advanced accounting homework help online
- Auditing homework writing help
- Human resource management homework help
- Nursing homework help online
- Psychology homework help online
- Sociology homework help online
- Ratio analysis homework help online
- Strategic Management Homework Help Online
- Mba operations management homework help
- Human resource management homework help
- Operations management homework help
- What is the optimal production plan for Q&H assuming no promotion by either Q&H or Unilock? What are the annual profits for Q&H?
- What are the profits for Q&H if Unilock promotes in April but Q&H does not promote throughout the year (it uses everyday low pricing)? What are the profits for Q&H if it promotes in April but Unilock does not promote throughout the year? Comment on the benefit from promoting versus the loss from not promoting if the competitor does.
- What are the optimal production plan and profits if both firms promote in April? Both promote in June? Q&H promotes in April but Unilock in June? Q&H promotes in June but Unilock in April?
- What is the best decision for Q&H if it can coordinate its decision with Unilock?
- What is the best decision for Q&H if it wants to maximize its minimum profits no matter what Unilock does?
Product code:Economics26QA