Create a template in excel for an aggregate plan

Assignment Help Supply Chain Management
Reference no: EM13541695

It is a spreadsheet for a specific manufacturing company that contains information regarding sales, purchasing spending, manufacturing costs, sales data, etc.

Create a template in Excel for an Aggregate Plan (by quarters not by month).

It has to include expected inventory levels and the number of people required to do the job each quarter.

It can be a Chase strategy or Level strategy.


Attachment:- DesignCaseStudy.xlsx

Reference no: EM13541695

Questions Cloud

Determine the mass of the ice cut out to make the hole : A student is ice fishing in Colorado on a frozen lake over spring break. He cuts a circular hole in the ice that has a diameter of 0.50 m. Find the mass of the ice cut out to make the hole
Explain d-aldopentose produced on optically inactive alditol : An optically active D-aldopentose produced on optically inactive alditol upon treatment with NaBH4. When this aldopentose was subjected to a Ruff degradation, a D-aldotetrose was generated.
Find the normal force between the ramp and the crate : The statue of Isaac Newton is crated and moved from the Oxford Museum of Natural History and Science for cleaning. find the normal force between the ramp and the crate
Standing on a spring scale in an elevator : Consider a 80.0-kg man standing on a spring scale in an elevator. Starting from rest, the elevator ascends, attaining its maximum speed of 1.46 m/s in 0.550 s. It travels with this constant speed for the next 5.00 s.
Create a template in excel for an aggregate plan : Create a template in Excel for an Aggregate Plan and it has to include expected inventory levels and the number of people required to do the job each quarter.
What is the work done on the puck while it is sliding : A 0.20 kg hockey puck slides across a frictionless ice rink at a constant speed of 25 m/s. Ignoring air resistance, what is the work done on the puck while it is sliding
Evaluate the ph of the solutions formed by dissolving : Calculate the pH of the solutions formed by dissolving 1.0g of each of the following substances in 500mL of solution
Three horizontal forces act on a packing crate on horizontal : Three horizontal forces act on a packing crate on a horizontal surface: 600 N to the left, 200 N to the right, and friction. The packing crate remains at rest. The weight of the crate is 400 N. If the 600 N force is removed, the net force acting on t..
Calculate the required vector electric field : One long wire carries current 20.0 A to the left along the x axis, A uniform electric field is applied to allow this particle to pass through this region undeflected. Calculate the required vector electric field

Reviews

Write a Review

Supply Chain Management Questions & Answers

  Calculate the response to selection

A population of sunflowers has an average time toflowering of 50 days.We select the sunflowers that floweredearliest; their average time to flowring is 35 days. We breed those5 early flowering plants with each other and plant the resultingseeds. w..

  Relationship between the strategic and the tactical

How do you perceive the relationship between the strategic and the tactical? word count 300 Harvard Referencing

  Supply chain practices of two or more different companies

Compare the supply chain practices of two or more different companies in the same industry or similar industries.Should one firm adopt another's superior practices, or are their situations sufficiently different that each is already optimised?Why?

  How much safety inventory of cell should retailer carry

The retailer is targeting a CSL of 95 percent and monitors its inventory continuously. How much safety inventory of cell phones should the retailer carry? What should its reorder point (ROP) be?

  Develop an analysis of the logistics process

Logistics Improvement Plan Proposal - Develop an analysis of the logistics process

  Explain principle of supply chain management

Which of the following is not a principle of supply chain management? Choose one answer.Segment customers by service needs and then tailor services to those particular segments

  Explain the levels of intensity in the distribution channel

Explain the levels of intensity in the distribution channel

  Difference between a gray box and a black box approach

What is the difference between a gray box and a black box approach to early supplier involvement? Under what circumstances might each approach be appropriate - Describe the different types of integration that supply management should actively beco..

  Find the optimal solution by using the graphical solution

Find the optimal solution by using the graphical solution technique and what is the value of the objective function? What are the values of all variables?

  Deciding to change levels of capacity

What issues need to be considered when deciding to change levels of capacity? How is this decision taken in your or well known industry.

  Develop a warehousing operational strategy

How should the chief warehouse manager of PCL approach problem and develop a warehousing operational strategy to overcome the problem and fulfill the redefined objectives of the firm.

  Estimate the annual carrying cost per item

Since you learned about the EOQ model in class, you want to compare your plan to order 100 units at a time with an EOQ solution. Assume that there are 365 working days a year and that lead time is 14 days. Consider only the inventory costs and ans..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd