Share
Explore BrainMass

Achieving Production plan target : XYZ manufactures

Please help me with the attached questions. Here is some of the material. See the attachment for more data.

XYZ manufactures artificial furs and sells to the retail market. The operations manager is trying to accomplish the inventory target of 6 days of supply on Jan, Feb, and Mar of the next year's production plan. The following shows the incomplete Sales and Operations' Planning Spreadsheet. Please complete the SOP plan and specifically answer the following questions.

a. Please identify which month meets the target and which month does not.
b. What is the production plan for the next three months (Jan, Feb, and Mar)?
c. What is the current situation at XYZ?

Necessary information
i. Assume all days of supply calculations are based on a 20-day month (Sales' working days).
ii. Units cost is 30$ per unit.
iii. Employee can produce 25 furs a day.

Attachments

Solution Preview

See the attached attached file. The text here maynot appear properly due to formatting issues. The question is not very clear as we cannot project the actual figures and can plan only on the basis of projections. There is no enough information provided to work with variance and confidence level. I have provided the best. Hope this will help. Thanks.

XYZ manufactures artificial furs and sells to the retail market. The operations manager is trying to accomplish the inventory target of 6 days of supply on Jan, Feb, and Mar of the next year's production plan. The following shows the incomplete Sales and Operations' Planning ...

Solution Summary

Answers a problem on operation management related to production plan. The solution is provided with explanation.

$2.19