Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Floyd A. Beams, Joseph H. Anthony, Bruce Bettinghaus, Kenneth Smith

11th Edition

978-0132568968, 9780132568968

More Books

Students also viewed these Accounting questions

Question

Describe the term career . AppendixLO1

Answered: 1 week ago