Provide the mrp tables for all the finished products

Assignment Help Financial Accounting
Reference no: EM13330855

Question 1

Frank's machine shop operates 250 days per year. Frank sells 5,000 units per year of his most popular item, a specialty gear. The set-up cost for this gear is £100 and the monthly unit cost of holding inventory is 1% of the production cost per unit, which is £50. The lead time is 10 days. When the gear is being produced, the shop can make 80 gears per day (Hint: You should use the production model for inventory management.).

Complete the following:

1. How many gears should be produced in each run and at what minimum cost?

2. What is the cycle time?

3. Find the reorder point.

4. Draw a graph to depict inventory level against time and show on it the quantities found above. Also, what is the maximum inventory level?

Question 2

For this part of the Individual Project, you need to use the POM-QM for Windows software:

1. Read Appendix IV of the Operations Management (Heizer & Render, 2011) textbook.

2. Launch the POM-QM for Windows software and from the main menu select Module, and then Materials Resource Planning.

3. Program the MRP for the Individual Project Problem below and solve it with the use of POM-QM for Windows.

The product structure tree for the finished product A is given below.

1890_What is the cycle time.png

The marketing department is estimating product A's demand to be 60 units for week 4 and 50 units for week 6. There is a scheduled receipt of 75 units for component D at the beginning of week 2. Various other MRP related information for the finished products and the components are provided below.

 

A

C

D

E

On hand

12

170

9

5

Lead time

2

2

1

1

Lot size

LFL

150+

multiples of 40

multiples of 22

Provide the MRP tables for all the finished products and the components for the next six weeks.

Reference no: EM13330855

Questions Cloud

Describe and explain oracle date and time format in details : Describe and explain Oracle Date and Time Format in details. Provide some Functions used for Date and Time and give some syntax example of their usage. Expand your examples to include some Arithmetic used with Oracle Date.
What is the value of bonds : What is the value of these bonds when the required interest rate is 5 percent, 10 percent, and 15 perrcent and why is the price of Bond L more sensitive to interest rate changes than the price of Bond S?
What is the change in the angular velocity of the rod : A thin rod has a length of 0.684 m and rotates in a circle on a frictionless tabletop. The axis is perpendicular to the length of the rod at one of its ends. what is the change in the angular velocity of the rod
Find the pitch of a roof : Find the pitch of a roof that has a 48 foot span, if the rafters upon which the roofing will be laid are 30  feet long, including a 4 foot overhang. Suppose that the entire roofline measures 100 feet from end to end.
Provide the mrp tables for all the finished products : Provide the MRP tables for all the finished products and the components for the next six weeks and draw a graph to depict inventory level against time and show on it the quantities found above. Also, what is the maximum inventory level?
Requirements of a unit record system : One way of assembling information necessary to treat a patient can be found in a unit record system. What are the requirements of a unit record system, what a unit record would include, and how the information is arranged.
What is the change in momentum of the ball during the hit : A tennis ball of mass 57 g is traveling in the + x direction with a speed of 38 m/s. What is the change in momentum of the ball during the hit
What is the ratio of your true weight vs apparent weight : on a ferris wheel with a 15 m radius, going one loop every 7 seconds, what is the acceleration? What is the ratio of your true weight vs apparent weight
What is the tangential acceleration of a point on the disk : A compact disk player has just been turned off. A disk decelerates uniformly from an initial angular velocity of 8.30 rev/s. What is the tangential acceleration of a point on the disk 3.60 cm from the axis

Reviews

Write a Review

Financial Accounting Questions & Answers

  Calculate variances that isolate the effects of price

Calculate variances that isolate the effects of price and usage changes in direct materials and direct manufacturing labor and discuss the pros and cons of immediately changing the standards.

  How much inventory was requisitioned for use on jobs

At the beginning of 2012, there was $1,600 of materials on hand. During the year, the company purchased $324,000 of materials; however it paid for only $314,000. How much inventory was requisitioned for use on jobs during 2012?

  Compare resultsfor the three cost flow assumptions

Compare resultsfor the three cost flow assumptions. What cost flow resultsin the lowest inventory value.

  Evaluate the value of each partners share of the business

Evaluate the value of each partner's share of the business and what was the basis of your computation of the partners' share of the business?

  What is the book value of the equipment

What is the book value of the equipment and does the balance in the accumulated depreciation account mean that the equipment's loss of value is $725,000? Explain.

  Greeting card industry position and formulating plan

Greeting card industry position and formulating plan - For the chosen trend, you are to comment on how the trend strengthens or weakens the competitive advantage and industry position strength of Shomei Cards and its competitors.

  Calculate the labor price and quantity variances

Calculate the labor price and quantity variances, assuming standard is 3.94 hours of direct labor at $12.37 per hour.

  What entry is necessary accounting records

What entry is necessary to adjust the accounting records for the change in accounting principle? (For multiple debit/credit entries, list amounts from largest to smallest eg 10, 5, 3, 2.)

  Provide examples to clarify and amplify your discussion

Describe key issues of the case as they relate to Mr. Friehling's actions, or inactions, in relation to the AICPA's Code of Professional Conduct. Identify as well as describe the issues and provide examples to clarify and amplify your discussion. ..

  Make interim financial statements for the first quarter

Calculation of ending inventory for interim financial statements - Ernst Equipment Co. wants to make interim financial statements for the first quarter. The company wishes to avoid making a physical count of inventory. Ernst's gross profit rate ave..

  Illustrate what is total amount of other financing source

Illustrate what is the total amount of other financing sources to be recognized on the fund-based financial statements over this six-year period?

  Find lower-of-cost-or-market inventory method

In the case of a taxpayer who uses the lower-of-cost-or-market inventory method and In comparing regular (C) corporations with individuals, which of the following, if any, relate only to (C) corporations

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