help with all questions and the parts with them please

Goulbum, Incorporated produces parts for heavy equipment used in mining and construction. The plant that produces one part common to many vehicles is highly automated, so all labor is considered part of factory overhead. The plant manager. who has just been promoted, would like to understand how overhead costs fluctuate in order to improve planning and budgets. After discussions with both financial and operations members of the plant staff, there is general agreement that the best cost driver for overhead is machine-hours. Monthly data were collected from the most recent two years on machine-hours and overhead. More months of data were available, but a process change had taken place about 30 months earlier, so the staff believed any data from before that time would be misleading. The data are shown in the following table: Required: a. Use the high-low estimation method to estimate the overhead cost behavior (fixed and variable components of cost) for the Goulburn plant. b. Prepare a scattergraph showing the overhead costs plotted against the machiriehours. c. Use a spreadsheet program to compute regression coefficients to describe the overhead cost equation. d. Use the results of your regression analysis to develop an estimate of overhead costs assuming 48,000 machine-hours will be worked next month. Genesee Fishing Tours (GFT) offers small group fishing expeditions off the local coast. The managers of the company are considering expanding the business to another city and want to put together a financial plan. As a part of that effort, the financial staff are analyzing the operating costs of GFT. They believe that a good predictor of operating cost is the number of clients that use the service. As a part of their analysis, they have collected 30 months of data on operating costs and number of clients, which follow: Required: a. Estimate the operating costs assuming 700 clients for the month using the high-low method. The Customer Support Department at Wadsworth Supply is analyzing the costs of its services. A cost analyst has collected monthly data on the three main functions of the department and the total costs for the last year, which follow. The cost analyst also has identified the Customer Support Department costs for each of the three main functions. Any costs not assigned to one of the functions is considered general administration cost. The costs for the last year (in thousands) follow: Required: a-1. What is the cost per unit for special reports completed? a-2. What is the cost per unit for customer accounts maintained? a-3. What is the cost per unit for transactions processed? b. Assuming the following level of cost-driver volumes for a month, what are the accounting department's estimated costs of doing business using the account analysis approach? - 40 special reports - 2,500 customer accounts maintained - 55,000 transactions processed Willis Cosmetics produces a variety of cosmetics and hair care products. One popular shampoo is produced at the company's Genoa Street Plant (GSP). The financial staff are in the process of revising the estimates for overhead and looking at different approaches. After much discussion, the staff selected direct labor costs as the best cost driver to explain overhead cost. The staff have collected monthly data on direct labor and overhead costs at GSP for the most recent fiscal year. The data follow: Required: a. Estimate the monthly fixed costs and the unit variable cost percentage of direct labor cost using the high-low estimation method. Note: Enter negative values with a minus sign. Goulburn, Incorporated produces parts for heavy equipment used in mining and construction. The plant that produces one part common to many vehicles is highly automated, so all labor is considered part of factory overhead. The plant manager, who has just been promoted, would like to understand how overhead costs fluctuate in order to improve planning and budgets. After discussions with both financial and operations members of the plant staff, there is general agreement that the best cost driver for overhead is machine-hours. Monthly data were collected from the most recent two years on machine-hours and overhead. More months of data were available, but a process change had taken place about 30 months earlier, so the staff believed any data from before that time would be misleading. The data are shown in the following table: Required: a. Use the high-low estimation method to estimate the overhead cost behavior (fixed and variable components of cost) for the Goulburn plant. b. Prepare a scattergraph showing the overhead costs plotted against the machinehours. c. Use a spreadsheet program to compute regression coefficients to describe the overhead cost equation. d. Use the re'sults of your regression analysis to develop an estimate of overhead costs assuming 48,000 machine-hours will be worked next month. Mendota Foods sells a variety of food products around the world. The company engages directly with individuals with an interest in cooking by offering ideas and recipes in various staff blogs and podcasts. The management team at Mendota believes this drives brand loyalty and allows Mendota to charge a premium for its products. One initiative that Mendota has been running for the last three years is a call center with staff who can provide help and answer questions about cooking in general and Mendota products in particular. The chief financial officer is interested in learning more about the costs of this initiative and how they vary with the demands placed on the center. To help answer the question, the financial staff have collected call center volume (number of calls) and call center cost for the last 12 months. During a discussion of those results, one of the cost analysts suggests that length of the calls (total hours) is probably a better driver of call center costs. The managers asked the analyst to collect the information and report on how it should be used. The combined data follow: b. Use the results of your high-low analysis to estimate the call center cost for a month with 16,000 hours of call center time. Mendota Foods sells a variety of food products around the world. The company engages directly with individuals with an interest in cooking by offering ideas and recipes in various staff blogs and podcasts. The management team at Mendota believes this drives brand loyalty and allows Mendota to charge a premium for its products. One initiative that Mendota has been running for the last three years is a call center with staff who can provide help and answer questions about cooking in general and Mendota products in particular. The chief financial officer is interested in learning more about the costs of this initiative and how they vary with the demands placed on the center. To help answer the question, the financial staff have collected call center volume (number of calls) and call center cost for the last 12 months. During a discussion of those results, one of the cost analysts suggests that length of the calls (total hours) is probably a better driver of call center costs. The managers asked the analyst to collect the information and report on how it should be used. The combined data follow: Using the results from a simple regression of call center cost on call center time (hours), input the following data: d-1. Enter the regression coefficients. d-2. Estimate the cost for a month with 16,000 hours of call center time using the results from a simple regression of call center cost on call center time (hours). Goulbum, Incorporated produces parts for heavy equipment used in mining and construction. The plant that produces one part common to many vehicles is highly automated, so all labor is considered part of factory overhead. The plant manager. who has just been promoted, would like to understand how overhead costs fluctuate in order to improve planning and budgets. After discussions with both financial and operations members of the plant staff, there is general agreement that the best cost driver for overhead is machine-hours. Monthly data were collected from the most recent two years on machine-hours and overhead. More months of data were available, but a process change had taken place about 30 months earlier, so the staff believed any data from before that time would be misleading. The data are shown in the following table: Required: a. Use the high-low estimation method to estimate the overhead cost behavior (fixed and variable components of cost) for the Goulburn plant. b. Prepare a scattergraph showing the overhead costs plotted against the machiriehours. c. Use a spreadsheet program to compute regression coefficients to describe the overhead cost equation. d. Use the results of your regression analysis to develop an estimate of overhead costs assuming 48,000 machine-hours will be worked next month. Genesee Fishing Tours (GFT) offers small group fishing expeditions off the local coast. The managers of the company are considering expanding the business to another city and want to put together a financial plan. As a part of that effort, the financial staff are analyzing the operating costs of GFT. They believe that a good predictor of operating cost is the number of clients that use the service. As a part of their analysis, they have collected 30 months of data on operating costs and number of clients, which follow: Required: a. Estimate the operating costs assuming 700 clients for the month using the high-low method. The Customer Support Department at Wadsworth Supply is analyzing the costs of its services. A cost analyst has collected monthly data on the three main functions of the department and the total costs for the last year, which follow. The cost analyst also has identified the Customer Support Department costs for each of the three main functions. Any costs not assigned to one of the functions is considered general administration cost. The costs for the last year (in thousands) follow: Required: a-1. What is the cost per unit for special reports completed? a-2. What is the cost per unit for customer accounts maintained? a-3. What is the cost per unit for transactions processed? b. Assuming the following level of cost-driver volumes for a month, what are the accounting department's estimated costs of doing business using the account analysis approach? - 40 special reports - 2,500 customer accounts maintained - 55,000 transactions processed Willis Cosmetics produces a variety of cosmetics and hair care products. One popular shampoo is produced at the company's Genoa Street Plant (GSP). The financial staff are in the process of revising the estimates for overhead and looking at different approaches. After much discussion, the staff selected direct labor costs as the best cost driver to explain overhead cost. The staff have collected monthly data on direct labor and overhead costs at GSP for the most recent fiscal year. The data follow: Required: a. Estimate the monthly fixed costs and the unit variable cost percentage of direct labor cost using the high-low estimation method. Note: Enter negative values with a minus sign. Goulburn, Incorporated produces parts for heavy equipment used in mining and construction. The plant that produces one part common to many vehicles is highly automated, so all labor is considered part of factory overhead. The plant manager, who has just been promoted, would like to understand how overhead costs fluctuate in order to improve planning and budgets. After discussions with both financial and operations members of the plant staff, there is general agreement that the best cost driver for overhead is machine-hours. Monthly data were collected from the most recent two years on machine-hours and overhead. More months of data were available, but a process change had taken place about 30 months earlier, so the staff believed any data from before that time would be misleading. The data are shown in the following table: Required: a. Use the high-low estimation method to estimate the overhead cost behavior (fixed and variable components of cost) for the Goulburn plant. b. Prepare a scattergraph showing the overhead costs plotted against the machinehours. c. Use a spreadsheet program to compute regression coefficients to describe the overhead cost equation. d. Use the re'sults of your regression analysis to develop an estimate of overhead costs assuming 48,000 machine-hours will be worked next month. Mendota Foods sells a variety of food products around the world. The company engages directly with individuals with an interest in cooking by offering ideas and recipes in various staff blogs and podcasts. The management team at Mendota believes this drives brand loyalty and allows Mendota to charge a premium for its products. One initiative that Mendota has been running for the last three years is a call center with staff who can provide help and answer questions about cooking in general and Mendota products in particular. The chief financial officer is interested in learning more about the costs of this initiative and how they vary with the demands placed on the center. To help answer the question, the financial staff have collected call center volume (number of calls) and call center cost for the last 12 months. During a discussion of those results, one of the cost analysts suggests that length of the calls (total hours) is probably a better driver of call center costs. The managers asked the analyst to collect the information and report on how it should be used. The combined data follow: b. Use the results of your high-low analysis to estimate the call center cost for a month with 16,000 hours of call center time. Mendota Foods sells a variety of food products around the world. The company engages directly with individuals with an interest in cooking by offering ideas and recipes in various staff blogs and podcasts. The management team at Mendota believes this drives brand loyalty and allows Mendota to charge a premium for its products. One initiative that Mendota has been running for the last three years is a call center with staff who can provide help and answer questions about cooking in general and Mendota products in particular. The chief financial officer is interested in learning more about the costs of this initiative and how they vary with the demands placed on the center. To help answer the question, the financial staff have collected call center volume (number of calls) and call center cost for the last 12 months. During a discussion of those results, one of the cost analysts suggests that length of the calls (total hours) is probably a better driver of call center costs. The managers asked the analyst to collect the information and report on how it should be used. The combined data follow: Using the results from a simple regression of call center cost on call center time (hours), input the following data: d-1. Enter the regression coefficients. d-2. Estimate the cost for a month with 16,000 hours of call center time using the results from a simple regression of call center cost on call center time (hours)