Production Plan Week 2 3 4 Total Forecast 3000 3500 3500 4000 Projected Available Balance 2000 Production Plan Model A Week 1 2 3 4 Total Forecast 2000 2000 2500 2000 Projected Available Balance 1500 MPS Model B Week 1 2 3 4 Total Forecast 1000 1500 1000 2000 Projected Available Balance 500 MPS

Understanding Business
12th Edition
ISBN:9781259929434
Author:William Nickels
Publisher:William Nickels
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
icon
Related questions
icon
Concept explainers
Topic Video
Question

. Worldwide Can-Openers, Inc., makes a family of two hand-operated can openers. The production plan is based on months. There are 4 weeks in this month. Opening inventory is 2000 dozen, and it is planned to increase that to 4000 dozen by the end of the month. The MPS is made using weekly periods. The forecast and projected available balance for the two models follow. The lot size for both models is 1000 dozen. Calculate the production plan and the MPS for each item.

Production Plan
Week
2
3
4
Total
Forecast
3000
3500
3500
4000
Projected Available Balance
2000
Production Plan
Model A
Week
1
2
3
4
Total
Forecast
2000
2000
2500
2000
Projected Available Balance
1500
MPS
Model B
Week
1
2
3
4
Total
Forecast
1000
1500
1000
2000
Projected Available Balance
500
MPS
Transcribed Image Text:Production Plan Week 2 3 4 Total Forecast 3000 3500 3500 4000 Projected Available Balance 2000 Production Plan Model A Week 1 2 3 4 Total Forecast 2000 2000 2500 2000 Projected Available Balance 1500 MPS Model B Week 1 2 3 4 Total Forecast 1000 1500 1000 2000 Projected Available Balance 500 MPS
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Understanding Business
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON