Mega Value's main product is the sugar lollipop. Each item is sold for $800 with a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Mega Value's main product is the sugar lollipop. Each item is sold for $800 with a profit margin of 25% each. The company orders 450,000 units quarterly and management wants to know the optimal order quantity. To place each order, the entity designates a single employee who is paid at a rate of $50 per hour which takes a maximum of five hours. The cost of holding each unit of inventory is $4. Management was advised by the supplier that a 2.5% discount will be given if the company doubles its current lot size. On the other hand, a 5% discount will be granted for two and a half times the current lot size and a 10% discount if the order size is four times the amount. Required: a) Calculate the EOQ based on the formula. b) Calculate the total cost based on the EOQ. c) Calculate the total cost for each individual alternate order quantity including the current policy. d) Which order quantity is considered the optimal order quantity and why? Mega Value's main product is the sugar lollipop. Each item is sold for $800 with a profit margin of 25% each. The company orders 450,000 units quarterly and management wants to know the optimal order quantity. To place each order, the entity designates a single employee who is paid at a rate of $50 per hour which takes a maximum of five hours. The cost of holding each unit of inventory is $4. Management was advised by the supplier that a 2.5% discount will be given if the company doubles its current lot size. On the other hand, a 5% discount will be granted for two and a half times the current lot size and a 10% discount if the order size is four times the amount. Required: a) Calculate the EOQ based on the formula. b) Calculate the total cost based on the EOQ. c) Calculate the total cost for each individual alternate order quantity including the current policy. d) Which order quantity is considered the optimal order quantity and why?
Expert Answer:
Answer rating: 100% (QA)
a To calculate the Economic Order Quantity EOQ we can use the formula EOQ 2 D S H Where D Demand per ... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these accounting questions
-
Moya's Tooth Pastry Place sells a wide variety of pastries. Their main pastry product is birthday cakes. The companys standard birthday cake sells for $5,000 each. The birthday cakes include a margin...
-
Ques 1: What is the major complaint by firms concerning the Sarbanes-Oxley act of 2012? A. the legislative maximum allowable compensation for a CEO. B. the legal requirement to disclose project...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Mike is a salesperson in a retail carpet store. He is paid $500 base salary per month plus 5% commission on sales over $10,000. His sales this month were $23,750. His total deductions were $152.75....
-
If an SEC-registered company uses the gross profit method to determine cost of goods sold for interim periods, would it be acceptable for the company to state that its not practicable to determine...
-
The Miss Manners Refinery in Dry Rock, Oklahoma, converts crude oil into gasoline. It takes 1 barrel of crude oil to produce 1 barrel of gasoline. In addition to the cost of oil there are some other...
-
In Figure Q24.1, suppose the magnet on the right is fixed in place and the magnet on the left is free to pivot about its center. Will the magnet on the left start to rotate? If so, will it initially...
-
Refer to the data in Exercise 16-22. Prepare a sales activity variance analysis for Data-2-Go like the one in Exhibit16.4. Flexible Budget Sales Activity Master Budget (based on planned (based on...
-
6. In 2022, Johnson Company contracted to deliver 100 boats to another company for $1,000,000 in 2023 and 2024. Outline the 5 step revenue recognition process based on FASB ASC 606 for this...
-
It is January 1, 2017 and Pegasus is contemplating the acquisition of competitor Chimera. The following details are available (S in millions except per share data): January 1, 2017 (S in millions)...
-
Consider what you have experienced at funerals, or seen on television or in films...what elements would you wish to be present at your own funeral? Why or why not would you include or exclude certain...
-
4. The following regression model has been estimated from a sample size of 42: P = 52.3510+ 0.1388S; + 15.3250C; P = home price in 000s of dollars, S = size of house in square feet, and C = 1 if the...
-
Autumn is depositing $575 at the beginning of every 6 months into an account with an interest rate of 3.67%, compounded semiannually. She wants to renovate her kitchen in 7 years. How much will...
-
How many electrons must be removed from a neutral, isolated conducting sphere to give it a positive charge of 8.0 x 108 C?
-
The Sister of the Spouse in a tax credit property is 15 years old. She receives $650 per month in social security. what is the The annual income from the social security to be included in the...
-
Compuglobal Corp. currently has $715,000 in accounts receivable and generated $4,350,000 in sales (all on credit) during the year that just ended. The firm's days sales outstanding (DSO) is days. Use...
-
1. (Supplemental Exercise - Required) For a recent season, several variables were recorded for 125 professional golfers. We are interested in using multiple regression to predict Earnings ($) from...
-
Assume Eq. 6-14 gives the drag force on a pilot plus ejection seat just after they are ejected from a plane traveling horizontally at 1300 km/h. Assume also that the mass of the seat is equal to the...
-
The Apollo Group is one of the largest providers of private education and runs numerous programs and services, including the University of Phoenix. Exhibit 3.23 provides statements of cash flows for...
-
Exhibit 4.22 presents selected operating data for three retailers for a recent year. Macy??s operates several department store chains selling consumer products such as brand-name clothing, china,...
-
Northrop Grumman Corporation is a leading global security company that provides innovative systems products and solutions in aerospace, electronics, information systems, shipbuilding, and technical...
-
See Table 2.5 showing financial statement data and stock price data for Mydeco Corp. a. Compute Mydecos PE ratio each year from 2019 to 2023. In which year was it the highest? b. What was Mydecos...
-
In early 2018, United Airlines (UAL) had a market capitalization of \($25.14\) billion, debt of \($12.73\) billion, and cash of \($5.59\) billion. United also had annual revenues of \($38.72\)...
-
See Table 2.5 showing financial statement data and stock price data for Mydeco Corp. a. Compute Mydecos ROE each year from 2019 to 2023. b. Compute Mydecos ROA each year from 2019 to 2023. c. Which...
Study smarter with the SolutionInn App