Problem 1: Arco Machines Inc. (Forecasting Costs) Lin, the owner of Arco Machines Inc., is trying...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Problem 1: Arco Machines Inc. (Forecasting Costs) Lin, the owner of Arco Machines Inc., is trying to forecast operating costs for the next month. Lin estimates that the company will utilize 10,000 machine hours next month. To estimate operating costs, Lin collected operating costs for the past 18 months Month Operating Costs # of Machine hours 1 $1,125,935 12,373 2 $1,169,406 16,452 3 $1,179,728 18,326 4 $1,097,830 10,680 5 $1,017,526 8,454 6 $1,107,438 12,342 7 $1,052,324 8,128 8 $1,066,952 10,545 9 $1,156,168 15,321 10 $1,121,332 15,462 11 $1,147,716 16,533 12 13 14 15 16 22456 $1,139,938 18,928 $1,201,681 19,741 $1,025,205 8,748 $1,051,026 11,247 $1,103,678 10,263 17 $1,080,449 10,354 18 $1,037,590 8,795 (1) Using High-Low method, a) What are the estimated monthly fixed costs and the estimated variable cost per machine hour? (2 points) b) What is the estimated operating cost of utilizing 10,000 machine hours if Lin uses the High-Low method? (2) Using simple regression, a) (1 point) What are the estimated monthly fixed costs and the estimated variable cost per machine hour? points) b) What percentage of the variation in costs is explained by the regression equation? (0.5 points) (2 Problem 1: Arco Machines Inc. (Forecasting Costs) Lin, the owner of Arco Machines Inc., is trying to forecast operating costs for the next month. Lin estimates that the company will utilize 10,000 machine hours next month. To estimate operating costs, Lin collected operating costs for the past 18 months Month Operating Costs # of Machine hours 1 $1,125,935 12,373 2 $1,169,406 16,452 3 $1,179,728 18,326 4 $1,097,830 10,680 5 $1,017,526 8,454 6 $1,107,438 12,342 7 $1,052,324 8,128 8 $1,066,952 10,545 9 $1,156,168 15,321 10 $1,121,332 15,462 11 $1,147,716 16,533 12 13 14 15 16 22456 $1,139,938 18,928 $1,201,681 19,741 $1,025,205 8,748 $1,051,026 11,247 $1,103,678 10,263 17 $1,080,449 10,354 18 $1,037,590 8,795 (1) Using High-Low method, a) What are the estimated monthly fixed costs and the estimated variable cost per machine hour? (2 points) b) What is the estimated operating cost of utilizing 10,000 machine hours if Lin uses the High-Low method? (2) Using simple regression, a) (1 point) What are the estimated monthly fixed costs and the estimated variable cost per machine hour? points) b) What percentage of the variation in costs is explained by the regression equation? (0.5 points) (2
Expert Answer:
Related Book For
Foundations of Finance The Logic and Practice of Financial Management
ISBN: 978-0132994873
8th edition
Authors: Arthur J. Keown, John D. Martin, J. William Petty
Posted Date:
Students also viewed these accounting questions
-
Exercise 11-3 (Algo) Transfer Pricing Basics [LO11-3] Sako Companys Audio Division produces a speaker that is used by manufacturers of various audio products. Sales and cost data on the speaker...
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
Consider a binomial distribution with 10 trials. Look at Table 2 in the Appendix showing binomial probabilities for various values of p, the probability of success on a single trial. (a) For what...
-
One reason you might choose to sync a SharePoint library to your computer is to Select an answer: have a separate copy that your colleagues can't affect have a separate copy in case SharePoint breaks...
-
Label this diagram.
-
List the skills that are needed by today's social media professionals. What topics should you study to prepare you for a career in this space?
-
About 83% of U.S. employees drive their own vehicle to work. You randomly select a sample of U.S. employees. Find the probability that more than 100 of the employees drive their own vehicle to work....
-
Quay Co. had the following transactions during the current period. Mar. 2 Issued 5,000 shares of $5 par value common stock to attorneys in payment of a bill for $30,000 for services performed in...
-
Skysong, Inc. had net income of $2017000 and paid dividends to common stockholders of $327000 in 2017. The weighted average number of shares outstanding in 2017 was 406000 shares. Skysong, Inc....
-
On 1st January 2019 the account receivable balance brought forward from the previous year totaled 140,900. During the year ended 31 December 2019, total sales amounted to 322,520 of which 85%...
-
1. How much did the cashier steal? a. 81,590 b. 71,950 c. 61,950 d. 71,590 2. What is the correct amount of cash to be shown on the statement of financial position on November 30, 2020? a. 1,828,212...
-
9. Given this piece of code fragment: (10%) for (int x = 0; x <10; x++) { } if (x % 4 >= 2) cout < < "OK" < < endl; Assuming the branch prediction by default is "TAKEN", (1) What is the accuracy of...
-
What recommendations and actions would you take to bring the budget back under control for the remaining quarters? How would you go about implementing these recommendations within your team? Draft a...
-
Start your SAS editor. 2. Open the "HW01_State_population" program in the program editor. 3. Add your name and student ID to the top of your program. 4. Run the program and create the "statepop" SAS...
-
Ingrid plans to live for two periods and only cares about consumption in the second period. She is considering studying towards a postgraduate degree in the first period. If she does it, it's going...
-
Elena, the front office clerk has asked you for an urgent appointment to see you. On arrival to the meeting, Elena explains to you that her supervisor in front office frequently makes silent...
-
on needs to begin work on the database for 4 Corners Pharmacy by creating the database in Access. He needs to create tables that will store the pharmacy\'s data to track customers, prescriptions,...
-
Assessing simultaneous changes in CVP relationships Braun Corporation sells hammocks; variable costs are $75 each, and the hammocks are sold for $125 each. Braun incurs $240,000 of fixed operating...
-
In computing the cost of capital, which sources of capital should be considered?
-
Why is a firms operating return on assets a function of its operating profit margin and total asset turnover?
-
The Fisayo Corporation wants to achieve a steady 7 percent growth rate. If it can achieve a 12 percent return on equity, what percentage of earnings must Fisayo retain for investment purposes?
-
PCs are considered risk-free investments. This makes them appealing to investors who are looking for protection against inflation but who do not have a lot of money to invest. How would you interest...
-
Samantha inherited a diamond-and-ruby necklace from her grandmothers estate. Unfortunately, the settings for the stones are damaged beyond repair. Samantha is trying to decide what to do with her...
-
Compare and contrast direct and indirect real estate investments.
Study smarter with the SolutionInn App