Question: can you answer please Required information Required information Excel Analytics 5-43: Interpretation of Cost Estimation Results: Visualization [The following information applies to the questions displayed

can you answer please  can you answer please Required information Required information Excel Analytics 5-43:
Interpretation of Cost Estimation Results: Visualization [The following information applies to the
questions displayed below.] Fiske Corporation manufactures a popular regional brand of kitchen
utensils. The design and variety has been fairly constant over the last

Required information Required information Excel Analytics 5-43: Interpretation of Cost Estimation Results: Visualization [The following information applies to the questions displayed below.] Fiske Corporation manufactures a popular regional brand of kitchen utensils. The design and variety has been fairly constant over the last three years. The managers at Fiske are planning for some changes in the product line next year, but first they want to understand better the relation between activity and factory costs as experienced with the current products. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from from the last three years of operations: Results from a multiple regression of factory costs on labor-hours and machine-hours using the data of Fiske Corporation are as follows: Results from a regression of factory costs on machine-hours are as follows: Equationt overhead =$1,770,363+($94.36 Machine-houra) Statintical data Correlation coefticient R2 Results from a multiple regression of factory costs on labor-hours and machine-hours are as follows: Rquetion Overheed =$993,339+(533.79 Machine-houra )+($120.26 Labor-houra) statistical data Correlation coeffiejent R2 Adjueted R2 1. Which of the following statements regarding these analyses is Answar: accurate? Unlike a regression analysis, the high-low approach : 2. Which of the following conclusions can be drawn from these simple regression analyses? 3. What are the estimated quarterly factory costs based on the multiple regression analysis using both labothours and machine-hours? 4. What are the estimated quarterly factory costs, assuming 21,000 machine-hours? 5. What are the estimated quarterly factory costs, assuming 16,000 laborhours? Required information Required information Excel Analytics 5-43: Interpretation of Cost Estimation Results: Visualization [The following information applies to the questions displayed below.] Fiske Corporation manufactures a popular regional brand of kitchen utensils. The design and variety has been fairly constant over the last three years. The managers at Fiske are planning for some changes in the product line next year, but first they want to understand better the relation between activity and factory costs as experienced with the current products. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from from the last three years of operations: Results from a multiple regression of factory costs on labor-hours and machine-hours using the data of Fiske Corporation are as follows: Results from a regression of factory costs on machine-hours are as follows: Equationt overhead =$1,770,363+($94.36 Machine-houra) Statintical data Correlation coefticient R2 Results from a multiple regression of factory costs on labor-hours and machine-hours are as follows: Rquetion Overheed =$993,339+(533.79 Machine-houra )+($120.26 Labor-houra) statistical data Correlation coeffiejent R2 Adjueted R2 1. Which of the following statements regarding these analyses is Answar: accurate? Unlike a regression analysis, the high-low approach : 2. Which of the following conclusions can be drawn from these simple regression analyses? 3. What are the estimated quarterly factory costs based on the multiple regression analysis using both labothours and machine-hours? 4. What are the estimated quarterly factory costs, assuming 21,000 machine-hours? 5. What are the estimated quarterly factory costs, assuming 16,000 laborhours

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

\f