Answered step by step
Verified Expert Solution
Question
1 Approved Answer
solve this for me, anyone. Using Multiple Regression Results to Construct and Apply a Cost Formula The controller for McGarvey Manufacturing Company felt that the
solve this for me, anyone.
Using Multiple Regression Results to Construct and Apply a Cost Formula The controller for McGarvey Manufacturing Company felt that the number of purchase orders alone did not explain the monthly purchasing cost. He knew that nonstandard orders (for example, one requiring an overseas supplier) took more time and effort. He collected data on the number of nonstandard orders for the past 12 months and added that information to the data on purchasing cost and total number of purchase orders. Number of Number of Purchase Nonstandard Purchasing Cost Month Orders Orders January $19,250 370 61 February 18,050 330 40 March 18,200 320 35 April 18,050 410 14 May 19,345 400 73 June 19,500 450 55 July 19,670 460 30 August 20,940 560 80 September 19,430 440 51 October 20,020 600 75 November 18,800 470 12 December 10 210 10n 27 October 20,020 600 75 November 18,800 470 12 December 19,340 480 27 Multiple regression was run on the above data; the coefficients shown by the regression program are: Intercept 14,650 (rounded to the nearest dollar) X variable 1 6.36 (rounded to the nearest cent) X variable 2 16.87 (rounded to the nearest cent) Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. + ($ x Purchase orders) + ($ x Nonstandard orders) 2. If McGarvey Manufacturing Company estimates that next month will have 450 total purchase orders and 42 nonstandard orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if McGarvey Manufacturing wants to estimate purchasing cost for the coming year and expects 6,000 purchase orders and 600 nonstandard orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) $ What is the total fixed purchasing cost? 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. + x Purchase orders) + ($ x Nonstandard orders) 2. If McGarvey Manufacturing Company estimates that next month will have 450 total purchase orders and 42 nonstandard orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if McGarvey Manufacturing wants to estimate purchasing cost for the coming year and expects 6,000 purchase orders and 600 nonstandard orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesn't it equal the fixed cost calculated in Requirement 2 above? because there are 12 months in the year Callie's Gym is a complete fitness center. Owner Callie Ducain employs various fitness trainers who are expected to staff the front desk and to teach fitness classes. While on the front desk, trainers answer the phone, handle walk-ins and show them around the gym, answer member questions about the weight machines, and do light cleaning (wiping down the equipment, vacuuming the floor). The trainers also teach fitness classes (e.g., pilates, spinning, body pump) according to their own interest and training level. The cost of the fitness trainers is $1,100 per month and $50 per class taught. Last month, 100 classes were taught. Required: 1. Develop a cost equation for total cost of labor. Total labor cost + per class taught 2. What was total variable labor cost last month? 3. What was total labor cost last month? 4. What was the unit cost of labor (per class) for last month? per class 5. What if Callie increased the number of classes offered by 50 percent? a. What would be the total labor cost? b. The unit labor cost? If required, round your answer to the nearest cent. per class
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