There is a new variant of COVID-19 called UNICRON-23. You volunteer at your town's community center....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
There is a new variant of COVID-19 called UNICRON-23. You volunteer at your town's community center. Tests will be self-collected at the community center to help promote efficiency and public health. When the locals arrive at the community center, they will receive a test kit and instructions. The annual demand for the UNICRON-23 specimen testing toolkit is 1,500 boxes. The carrying/holding cost per box per year is $120, and the processing fee for an order is $40. The purchase price per testing toolkit is $450. ● Assume that demand is known and constant. ● ● Please complete the following in Excel: 1. Determine the optimal order quantity for the Specimen Testing Toolkit. 2. Determine the total annual ordering and carrying/holding costs. 3. The community center's managers would prefer to set the carrying/holding cost as a percentage of purchase price, so 30% of the item's price was determined to be appropriate. What are the new optimal order quantity and total costs? 4. What is the relative difference between the economic order quantities (EOQs) found in #1 and #3? What is the relative difference in total annual costs found in #2 and #3? (This is a simple difference calculation in %.) There is a new variant of COVID-19 called UNICRON-23. You volunteer at your town's community center. Tests will be self-collected at the community center to help promote efficiency and public health. When the locals arrive at the community center, they will receive a test kit and instructions. The annual demand for the UNICRON-23 specimen testing toolkit is 1,500 boxes. The carrying/holding cost per box per year is $120, and the processing fee for an order is $40. The purchase price per testing toolkit is $450. ● Assume that demand is known and constant. ● ● Please complete the following in Excel: 1. Determine the optimal order quantity for the Specimen Testing Toolkit. 2. Determine the total annual ordering and carrying/holding costs. 3. The community center's managers would prefer to set the carrying/holding cost as a percentage of purchase price, so 30% of the item's price was determined to be appropriate. What are the new optimal order quantity and total costs? 4. What is the relative difference between the economic order quantities (EOQs) found in #1 and #3? What is the relative difference in total annual costs found in #2 and #3? (This is a simple difference calculation in %.)
Expert Answer:
Answer rating: 100% (QA)
Certainly I can help you with the calculations Lets work through each question step by step Question ... View the full answer
Related Book For
Advanced Accounting
ISBN: 978-0077431808
10th edition
Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik
Posted Date:
Students also viewed these general management questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
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...
-
Investors should expect to be compensated for bearing_____ risk, but they should not expect to be compensated for bearing_____ risk. a. Unsystematic: systematic b. Unsystematic; co-movement c....
-
Jacobs Department Stores has just installed new electronic cash registers in its stores. How do cash registers improve internal control over cash receipts?
-
What error results if the curvature and refraction correction is neglected in trigonometric leveling for sights? (a) 3000 ft long (b) 500 m long (c) 5000 ft long
-
A heating element in a toaster dissipates \(900 \mathrm{~W}\) when run at \(120 \mathrm{~V}\). How much charge passes through the heating element in 1 minute?
-
Vintage Dresses Inc. manufactures dresses in a small manufacturing facility. Manufacturing has 20 employees. Each employee presently provides 35 hours of productive labor per week. Information about...
-
Block Distortion Measurement (BDM) is used to estimate the motion vector for a block of pixels. One of the most common ways of doing this is by minimising the Sum of Absolute Differences (SAD) (i)...
-
Aman and Juanita have $150,000 in their business bank account. You have calculated their warehouse stock and equipment to be valued at a total of $480,000. They want to take out a policy for...
-
What would be the ideal management of a woman with infertilty who is detected to have bilateral cornual block on hysterosalpingography? a) Tuboplasty b) In-vitro fertilization c) Hydrotubation d)...
-
Our company has Treasury bills in its portfolio for a nominal value of 300,000 euros, were acquired at auction at 7.75% interest and with maturity 92 days (take 10,000 as nominal per letter). Ten...
-
Kerry Corporation must pay $500,000 to its supplier. Kerry's bank has offered a 270-day simple interest loan with a quoted interest rate of 12 percent. The bank requires a 20 percent compensating...
-
How many years would it take an investment of $ 4 5 8 . 0 0 to grow to $ 3 0 , 5 2 8 . 0 0 at an annual rate of return of 8 . 4 6 % ?
-
Suppose a firm will invest $ 5 0 0 today, $ 6 0 0 a year from now, $ 7 0 0 two years from now, $ 8 0 0 three years from now, and $ 9 0 0 four years from now. What will the future value of the project...
-
Last week, Bayonetta opened a new wealth management account at the Capital Bank of Noatun to begin saving for retirement. Today, Bayonetta deposited $135,000 into her account. She then plans to make...
-
WACC Assignment You recently went to work for CTC Components Company, a supplier of auto repair parts used in the after-market with products from Daimler AG, Ford, Toyota, and other automakers. Your...
-
Diamond Walker sells homemade knit scarves for $25 each at local craft shows. Her contribution margin ratio is 60%. Currently, the craft show entrance fees cost Diamond $1,500 per year. The craft...
-
On December 1, 2011, Barnum Company (a U.S.-based company) entered into a three-month forward contract to purchase 1,000,000 ringgits on March 1, 2012. The following U.S. dollar per ringgit exchange...
-
Under Lennon Hospitals rate structure, it earned patient service revenue of $9 million for the year ended December 31, 2010. However, Lennon did not expect to collect this entire amount because it...
-
On June 1, Cline Co. paid $800,000 cash for all of the issued and outstanding common stock of Renn Corp. The carrying values for Renns assets and liabilities on June 1 follow: Cash . . . . . . . . ....
-
Kids Sports Consulting Pty Ltd is a company set up by sports and recreation management students to gain experience in running their own business. It had the following contribution margin income...
-
V. Zarb, the marketing manager for Maltese Treasures Ltd, is preparing a sales budget for the year ended 30 June 2020. In reviewing the actual sales data for the previous year, the sales and...
-
The following expenses budget has been prepared for Abacus Services for the year ending 30 June 2020. Professional salaries, secretarial wages and training are paid in the quarter in which they are...
Study smarter with the SolutionInn App