The partially completed inventory record for the driveshaft subassembly in the table below shows gross requirements, scheduled receipts, lead time, and current on-hand inventory. a. Complete the last three rows of the record for an FOQ of 55 units. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Driveshaft subassembly Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases 15 1 40 70 45 0 2 25 20 3 10 10 0 4 20 45 55 Lot Size: FOQ = 55 units Lead Time: 3 weeks Week 5 50 50 55 6 50 0 0 7 40 15 55 8 40 30 55

The partially completed inventory record for the driveshaft subassembly in the table below shows gross requirements, scheduled receipts, lead time, and current on-hand inventory. a. Complete the last three rows of the record for an FOQ of 55 units. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Driveshaft subassembly Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts Planned order releases 15 1 40 70 45 0 2 25 20 3 10 10 0 4 20 45 55 Lot Size: FOQ = 55 units Lead Time: 3 weeks Week 5 50 50 55 6 50 0 0 7 40 15 55 8 40 30 55

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Which is difficult to handle labor shortage or labor surplus(. Explain 100 words)
Please do not give solution in image formate thanku.
Your company wants to replicate its travel expense management process from paper-based to an electronic process. In the current process, an employee wishing to travel would simply complete a travel notification form and send to his/her supervisor, and keep a copy. There is no requirement for the supervisor to approve the form prior to the employee travel. At the end of the travel, the employee attaches his/her travel expense receipts to his/her copy of the travel notification form and submits to the supervisor for approval. For this project, the company has indicated that it does not plan to change any aspect of the paper-based travel expense management process, at least initially, even though not doing so could expose the company to various types of risks. You have been appointed the project manager for this project, and one of your responsibilities is to assess the risks associated with replicating the paper-based travel expense management process without introducing any new controls…
Please answer queation 3 only
()9 please answer the questions in a ABCD form THANK YOU FOR YOUR HELP!! (Please igonore numbers on screen) Answers are sometimes shown in second image, Please select as many answers , if they're correct of course, once again thank you.
Specific Task Performed WEEK 1 Problems Encountered Canvassing for a Some prices are not We searched for cheaper purchase updated. another file that was updated in price. Answering phone The voice of the calls from other employee departments is low/weak counting materials, equipment, merchandise, or supplies in stock. Solutions Applied I Assist in stocking The office is not and distributing supplies in different departments. wide, so that we encounter problem to where we can put the large number of supplies ask employee on what she is saying. the supplier. Assist in the There are supplies We checked the I learned the basics of that lack of numbers. past request of activities related and to form receiving logbook to confirm the lack of supplies. Learning Outcomes Ma'am Joy- the property specialist, said that we can put the extra supplies in our office. I learned that if you want to get the best price, you cannot simply purchase a single from Summary report: inventory management tasks.…
3. Duplication of work able to reduce the cost of organizing. (True/ False)
What is meant by trial closing?
Policies, rules, procedures and regulations are required in the firm. Explain their significant effects on the operations of the firms? (600 words)
please help walk me step by step to solve.
Each Triam Deluxe gamer computer system consists of two speakers, a monitor, a system unit, a keyboard, and an installation kit. These pieces are packed together and shipped as a complete kit. In MRP terms, all of these items are level 1 items that make the level 0 kits. Complete the MRP records, using the following information: • Production plans for complete kits are as follows: Start assembling 4,500 kits in week 2 Start assembling 1,000 kits in weeks 3, 4, and 5 Start assembling 8,000 kits in week 6 • The gross requirements for the system unit have already been given to you. For the remaining items, you will need to figure out the gross requirements. • All scheduled receipts, lead times, and beginning inventory levels are shown. Click the icon to view the MRP records. Construct the material requirements plan for item System unit (enter your responses as whole numbers). System unit: Lead Time = 1 week; Minimum order quantity = 3,500 Week 1 2 3 Gross requirements 4,500 1,000…
Preview File Edit View Go Tools Window Help 84% t my.charlotte.edu MBAD 6141 U90 SpringX G According to Trevino ar X B Weaver Chocolate Co. X C Get Homework Help WiX a Stevenson, W. J. - Operations management. (14th ed.). McGraw-Hill-Mcgraw-Hill (2021).pdf (page 576 of 929) Search 6100 pur uay. 1 TIC Capacity 1or prodUCIng tic PTOGUCT IS U TWIIS Pur uay. Dulup COsis PIOU, anu stoTagt anu 202210-MBAD handling costs are $5 per ton a year. The firm operates 200 days a year. (Note: 1 ton = 2,000 pounds.) odf a. How many bags per run are optimal? Spring 2022 b. What would the average inventory be for this lot size? c. Determine the approximate length of a production run, in days. Extra Асcount Home Zoom d. About how many runs per year would there be? Dashboard 21 Announcements e. How much could the company save annually if the setup cost could be reduced to $25 per run? Modules vaccine and other info 11. A company is about to begin production of a new product. The manager of the department…