Attachment # 00012227 - Week_3_Question.xlsx
Week_3_Question.xlsx (20.73 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
WeekQuantityEngine Assembly Master ScheduleGross RequirementsScheduled ReceiptsProjected Available BalanceNet RequirementsPlanned Order ReleaseGear box requirementsInput shaft requirementsPlanned Order ReceiptFrom E12 for 2 Weeks Lead TimeFrom F24 for 3 Weeks Lead TimeSince Input Shaft is 2 X Gear Box, then each week is 2 X Row 13From ProblemSince Gear box 1 X Engine Assembly, use Master Engine Assembly QtyCell B10, Beg Balance of 17- Gross Requirement of 15Cell C10 CarryoverCell B22, Beg Balance of 40- Gross requirement of 10Week 5 and beyond 0 since no scheduled receiptsNet Req=Gross Req-Projected Available Balance from prior weekPlanned Order Receipt from 3 weeks in futureSame as row abovePart 2Gear BoxGiven InformationSetup per order= Inventory Carrying Cost per unit per periodInput ShaftNumber of orders ( count cells with values for planned order release)Set-up Costs=# of Orders X Setup Costs(8*90)Inventory(2+2)*Inventory Carrying CostTotalSetup Costs=5 orders*45Inventory=(30+32+32+2)*1Total Cost Next cell, Gross Req-Scheduled ReceiptsLead TimeStagger Order Releases to reduce CostsWeek 4 and beyond 0 since no scheduled receipts3*90)(88)*Inventory Carrying Costsum of projected available balanceSetup Costs=2 orders*45Inventory=(74)*1Planned order receipt=projected available balance +net requirements
GCU MGT655 2020 June Week 3 Assignment Latest

GCU MGT655 2020 June Week 3 Assignment Latest

Question # 00774646 Posted By: rey_writer Updated on: 08/22/2020 07:51 AM Due on: 08/22/2020
Subject Education Topic General Education Tutorials:
Question
Dot Image

MGT655 Operations Management

Week 3 Assignment  

Inventory Management

Refer to the Excel speadsheet, "Inventory Management," to complete the "Analytics Exercise: An MRP Explosion - Brunswick Motors," at the end of Chapter 21 in the textbook. Answer Questions 1-3.

MGT-655-InventoryManagement.xlxs

APA format is not required, but solid academic writing is expected.

Dot Image
Attachments
Week_3_Question.xlsx (20.73 KB)
Tutorials for this Question
  1. rey_writer
    Tutorial # 00774291 Posted By: rey_writer Posted on: 08/22/2020 07:52 AM
    Puchased By: 2
    Tutorial Preview
    The solution of GCU MGT655 2020 June Week 3 Assignment Latest...
      Get the Solution
    Attachments
    Week_3_Assignment_Inventory_Management.xlsx (23.78 KB)
Whatsapp Lisa