Question: a ) What is the optimal aggregate plan for a wine distributor company that imports and repackages wine for retail sale? The company has 2
a What is the optimal aggregate plan for a wine distributor company that imports and repackages wine for retail sale? The company has employees, each capable of packaging bottles of wine per day. The inventory holding cost is $ per bottle per month, and the backlog cost is $ per bottle per month. The workers earn $ each per month. Given the demand and working days for January to June, assess the aggregate plan without allowing backlogs, and determine if cost savings can be achieved by permitting backlogs.
tableMonthJan,Feb,Mar,Apr,May,JuneDemandWorking days,
b The distributor company is contemplating the utilization of temporary personnel during peak demand periods. These temporary workers can be sourced from a local staffing agency, incurring a cost of $ per month along with a onetime fee of $ If the temporary workers exhibit efficiency comparable to regular employees, is it possible for the company to lower its expenses by hiring temporary staff?
Use excel solver to answer the question and add all excel solver steps and screenshot in detail
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
