Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Maureen Stone is the new manager of the materials storeroom for Burfield Manufacturing. Maureen has been asked to estimate future monthly purchase costs for
Maureen Stone is the new manager of the materials storeroom for Burfield Manufacturing. Maureen has been asked to estimate future monthly purchase costs for part #696, used in two of Burfield's products. Maureen has purchase cost and quantity data for the past 9 months as follows: (Click the icon to view the data for the past nine months.) Estimated monthly purchases for this part based on expected demand of the two products for the rest of the year are as follows: (Click the icon to view the expected demand for the rest of the year.) Required Data for last 9 months Month Requirement 1. The computer in Maureen's office is down, and Maureen has been asked to immediately provide an equation to estimate the future purchase cost for part #696 equation does she get? January February $ Cost of Purchase 12,687 Quantity Purchased 2,650 parts hat 12,220 2,800 March 17,673 4,116 Complete the equation below. April 16,115 3,761 Purchase costs (y) = $1209+ ($ 4 x Quantity purchased (X)) May 13,000 2,934 Requirement 2. Using the equation from requirement 1, calculate the future expected purchase costs for each of the last three months of the year. June 14,038 3,332 Month October Purchase Quantity Expected 3,320 parts High-Low Method Expected Cost July 15,316 3,600 August 10,073 2,216 September 14,970 3,512 November December 3,740 parts 3,060 parts - X Expected demand for rest of the year Month October November December Purchase Quantity Expected 3,320 parts 3,740 3,060 Print Done Print Done
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started