F You recently overheard that your company's competitors have started to purchase their materials from an...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
F You recently overheard that your company's competitors have started to purchase their materials from an online marketplace. You identify your company's top three products and collect information about their material usage, their standard costs, and the average costs you find from the sellers on the online marketplace at the end of December 2020. Here are the definitions of the fields. Online Marketplace Material usage data set. Material ID: a unique identifier for each raw material. Product ID: a unique identifier for each product. Standard usage: the standard usage of materials for a specific product. ■ Online Marketplace Price data set ⚫ Standard price: the standard purchasing price for one unit of each raw material. Material ID: a unique identifier for each material. Grade main: the grade level of the material. (Note: The company only keeps materials with grade level "A") Quantity on hand: the number of units of the raw material on hand in inventory Marketplace vendor: vendor for raw materials on the online marketplace. Avgtransactionprice: average transaction price per unit for a specific vendor and a specific raw material. Required Use the Online Marketplace data sets available in Wiley Course Resources to answer the following questions about the online marketplace. a. If the company had purchased all of its materials from the online marketplace, what inventory cost would be shown for all materials on hand based on the average transaction price? Is that value higher or lower than the value of all materials if using their standard price? b. If the company can freely choose the lower of the standard price or the average price in the online marketplace, what is the lowest possible inventory cost of all materials on hand? c. Is there a particular marketplace vendor that always sells at a price lower than the standard price? d. Based on your observations in (a) and (b), can you explain why the competitors are switching to the online marketplace? What would you recommend to your company? F You recently overheard that your company's competitors have started to purchase their materials from an online marketplace. You identify your company's top three products and collect information about their material usage, their standard costs, and the average costs you find from the sellers on the online marketplace at the end of December 2020. Here are the definitions of the fields. Online Marketplace Material usage data set. Material ID: a unique identifier for each raw material. Product ID: a unique identifier for each product. Standard usage: the standard usage of materials for a specific product. ■ Online Marketplace Price data set ⚫ Standard price: the standard purchasing price for one unit of each raw material. Material ID: a unique identifier for each material. Grade main: the grade level of the material. (Note: The company only keeps materials with grade level "A") Quantity on hand: the number of units of the raw material on hand in inventory Marketplace vendor: vendor for raw materials on the online marketplace. Avgtransactionprice: average transaction price per unit for a specific vendor and a specific raw material. Required Use the Online Marketplace data sets available in Wiley Course Resources to answer the following questions about the online marketplace. a. If the company had purchased all of its materials from the online marketplace, what inventory cost would be shown for all materials on hand based on the average transaction price? Is that value higher or lower than the value of all materials if using their standard price? b. If the company can freely choose the lower of the standard price or the average price in the online marketplace, what is the lowest possible inventory cost of all materials on hand? c. Is there a particular marketplace vendor that always sells at a price lower than the standard price? d. Based on your observations in (a) and (b), can you explain why the competitors are switching to the online marketplace? What would you recommend to your company?
Expert Answer:
Answer rating: 100% (QA)
Analyzing Online Marketplace Data Unfortunately I dont have access to the specific Online Marketplace data sets you mentioned available in Wiley Cours... View the full answer
Related Book For
Accounting Information Systems Controls and Processes
ISBN: 978-1119329565
3rd edition
Authors: Leslie Turner, Andrea Weickgenannt, Mary Kay Copeland
Posted Date:
Students also viewed these accounting questions
-
Pixystems Toys is a leading manufacturer and distributor of childrens toys across the globe through third party distributors (non-company owned stores) and through their flagship store located in New...
-
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...
-
Now apply one of those decision making models (Philosophical) to this scenario: Scenario: You are a CPA in the accounting department at a HealthCare System with three other accountants. You are good...
-
Ehrlich Co. began business on January 2, 20Y8. Salaries were paid to employees on the last day of each month, and social security tax, Medicare tax, and federal income tax were withheld in the...
-
Phone calls arrive at the rate of 30 per hour at the reservation desk for Regional Airways. Use e1 = 0.36788 to answer the following questions. 28. What is the probability of receiving more than two...
-
The table below reports the unemployment rate, labor force participation rate, and (working-age) population for the United States in January 2008, 2011, and 2016. Using the data, answer the following...
-
For the last eleven years, Lime Corporation has owned and operated four different trades or businesses. Lime also owns stock in several corporations that it purchased for investment purposes. The...
-
How does the use of dynamic process simulation differ from steady-state simulation, particularly in terms of modeling process transients and evaluating system robustness to disturbances ?
-
in your opinion, are there any aspects of social order that the Seven Commandments fail to cover?
-
Discuss how improper maintenance policies lead to business continuity problems.
-
Explore the uses of regression analysis as a tool for risk and business continuity management.
-
How does CRM offer advantages to salespeople in terms of information management? What are some of the problems you could predict for salespeople in firms that do not use CRM?
-
What are some problems that occur in supply chain risk analysis that a simulation model can address?
-
Sales managers ranked success factors for sales recruits as listening skills first, follow-up skills second, and ability to adapt sales style from situation to situation third in importance. Why do...
-
Question 4: You repeatedly flip a fair coin and stop as soon as you get tails followed by heads. (All coin flips are mutually independent.) Consider the random variable X = the total number of coin...
-
Southwestern Punch was made by Frutayuda, Inc. and sold in 12-ounce cans to benefit victims of Hurricane Zero. The mean number of ounces placed in a can by an automatic fill pump is 11.7 with a...
-
Which type of users should have access to an extranet?
-
Inner Artist is a retailer of arts and craft supplies in the suburban Chicago area. It operates a single retail store and also has extensive catalog sales on account to area schools, churches, and...
-
What are the ten areas of privacy practices described in the Online Privacy section of the AICPA Trust Services Principles?
-
One of the main fears that retail startups have is if they will be able to compete against Walmart, Home Depot, and the other big-box stores. This is a legitimate fear. Big-box stores continue to...
-
Influencer marketing is a type of marketing where companies partner with influencers, who have a significant following on social media platforms, to promote their products or services. Influencers...
-
In the summer of 2015, Stephen Kuhl and Kabeer Chopra made their way to Philadelphia to prepare for business school. It was their first semester in the Wharton MBA program. They were both in an...
Study smarter with the SolutionInn App