Fixed costs Direct material cost per unit Direct labor cost per unit Overhead per unit Transportation...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Fixed costs Direct material cost per unit Direct labor cost per unit Overhead per unit Transportation cost per unit Which location would minimize the total costs, given an annual production of 60,000 units? The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet Location 1 Location 2 Location 3 $120,000 $165,000 $140,000 $8.60 $8.80 $8.50 $4.90 $5.10 $4.40 $1.20 $1.10 $1.00 $1.35 $1.65 $1.50 Questions. 1. What are the total annual costs for each of the locations? Round your answers to the nearest dollar. Total Location 1 Location 2 $ Location 3 Excel File B13 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 template - Saved Data Home V A Location Analysis Annual Production osts Insert X fx Fixed Costs Direct material cost/unit Direct labor cost/unit Overhead/unit Transportation cost/unit Arial Fixed Costs Direct material cost Direct labor cost Overhead 21 22 Formulas Transportation cost Total Least-cost location Draw' B Location 1 Page Layout Location 1 $120,000.00 Location 1 10 $8.60 $4.90 $1.20 $1.35 60000 B Location 2 Location 2 O Search (Alt + Q) $165,000.00 Location 2 Formulas $8.80 $5.10 $1.10 $1.65 D Location 3 Data Location 3 $140,000.00 Location 3 A v $8.50 $4.40 $1.00 $1.50 Review E View Help F ab G Currency H File S B13 < V < > Home 11 12 Total Costs 13 14 15 16 17 18 19 20 21 22 Formulas 23 24 25 26 27 28 29 30 31 32 - V M A Insert Arial X fx Fixed Costs Direct material cost Direct labor cost Overhead Transportation cost Total Least-cost location Fixed Costs Direct material cost Direct labor cost Overhead Transportation cost Total Least-cost location Sheet1 + Draw B Location 1 Location 1 #N/A #N/A #N/A #N/A #N/A #N/A #N/A Page Layout 10 V B Location 2 Location 2 #N/A #N/A #N/A #N/A #N/A #N/A Formulas Search (Alt+Q) V D Location 3 Location 3 #N/A #N/A #N/A #N/A #N/A #N/A Data Review ... E View F ab Help P G Currency H Fixed costs Direct material cost per unit Direct labor cost per unit Overhead per unit Transportation cost per unit Which location would minimize the total costs, given an annual production of 60,000 units? The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet Location 1 Location 2 Location 3 $120,000 $165,000 $140,000 $8.60 $8.80 $8.50 $4.90 $5.10 $4.40 $1.20 $1.10 $1.00 $1.35 $1.65 $1.50 Questions. 1. What are the total annual costs for each of the locations? Round your answers to the nearest dollar. Total Location 1 Location 2 $ Location 3 Excel File B13 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 template - Saved Data Home V A Location Analysis Annual Production osts Insert X fx Fixed Costs Direct material cost/unit Direct labor cost/unit Overhead/unit Transportation cost/unit Arial Fixed Costs Direct material cost Direct labor cost Overhead 21 22 Formulas Transportation cost Total Least-cost location Draw' B Location 1 Page Layout Location 1 $120,000.00 Location 1 10 $8.60 $4.90 $1.20 $1.35 60000 B Location 2 Location 2 O Search (Alt + Q) $165,000.00 Location 2 Formulas $8.80 $5.10 $1.10 $1.65 D Location 3 Data Location 3 $140,000.00 Location 3 A v $8.50 $4.40 $1.00 $1.50 Review E View Help F ab G Currency H File S B13 < V < > Home 11 12 Total Costs 13 14 15 16 17 18 19 20 21 22 Formulas 23 24 25 26 27 28 29 30 31 32 - V M A Insert Arial X fx Fixed Costs Direct material cost Direct labor cost Overhead Transportation cost Total Least-cost location Fixed Costs Direct material cost Direct labor cost Overhead Transportation cost Total Least-cost location Sheet1 + Draw B Location 1 Location 1 #N/A #N/A #N/A #N/A #N/A #N/A #N/A Page Layout 10 V B Location 2 Location 2 #N/A #N/A #N/A #N/A #N/A #N/A Formulas Search (Alt+Q) V D Location 3 Location 3 #N/A #N/A #N/A #N/A #N/A #N/A Data Review ... E View F ab Help P G Currency H
Expert Answer:
Answer rating: 100% (QA)
Location Analysis for Minimizing Total Costs 1 Total Annual Costs for Each Location Location 1 Fixed ... View the full answer
Related Book For
Managerial Accounting
ISBN: 9781259275814
11th Canadian Edition
Authors: Ray H Garrison, Alan Webb, Theresa Libby
Posted Date:
Students also viewed these finance questions
-
Do you believe healthcare in the United States is a "right" or a "privilege"? Why or why not? (Add citations)
-
The Hampshire Company manufactures umbrellas that sell for $12.50 each. In 2014, the company made and sold 60,000 umbrellas. The company had fixed manufacturing costs of $216,000. It also had fixed...
-
As a leader what are some of the thoughtful and creative ideas that you have implemented to motivate your team and increase job satisfaction?
-
pthyon Carleton student ID). Add a function named find_diff() to your program that takes a 2-D list of any size containing some positive integers. Your function must find the difference between the...
-
The management of office printing, duplicating, filing, and overall document storage is one of the most significant overhead costs in many companies, especially companies with large and complex...
-
Waterkraft rents canoes and other water crafts to campers and hikers. On April 15, 2020, Waterkraft prepared their semi- monthly payroll for their employees. The current CPP rate is 5.25%, the...
-
When does it make sense for an organization to consider forming an endowment? How would an endowment influence the need for fundraising?
-
Draw a project network from the following information. Activities B and H can be shortened to a minimum of 2 weeks. Which activity would you shorten to reduce the project duration by 2 weeks?Why?...
-
1. Perform an Internet search on the Toyota Production System (TPS). How does Toyota build quality into every car it assembles? Now take a look at JD Power's quality ratings over time. How has...
-
Gary Hudson was born and raised in Pensacola, Florida. He obtained his bachelors degree in business from Florida State University, where he enrolled in the NROTC (Naval Reserve Officers Training...
-
Explain how the capital charge for foreign exchange risk is calculated in the BIS standardized model. If an FI has an $80 million long position in Euros, a $40 million short position in British...
-
Porter Company is analyzing two potential investments. Project X $ 72,790 Initial investment Net cash flow: Year 1 Year 2 Year 3 Year 4 25,000 25,000 25,000 0 Project Y $ 62,000 4,200 27,000 27,000...
-
Yummy Gummy is an American ice cream brand that has been in Canada for years. They work with a multitude of local Canadian owners who purchase the ingredients and use the recipes for Yummy Gummy...
-
A semi-circular loop with radius R = 32.1 cm, carrying current 0.503 A is placed in a magnetic field of strength B-444 mT, as shown in the picture. What is the magnitude of the torque exerted on the...
-
A space explorer who does a little anthropology on the side, observes the natives of a distant planet emitting mating calls. Ronald Qrxxt emits a mating call having a frequency of 200-Hz. This tone...
-
1. Create an HTML file called as4.html. In it include the following: an h1 element containing "Assignment 4" an h2 element containing the name of your favourite sport or hobby a p element with a...
-
The pipe system below consists of a 2-in-diameter pipe which is 50-ft-long in total. There is a flush entrance, two elbows, and a fully open gate valve. With the manufacturers pump curve given and...
-
Huntingdon Capital Corp. is a competitor of Plazacorp and First Capital Realty. Huntingdon reported the following selected information (in millions):...
-
Name the two approaches to break-even analysis. Briefly explain how each approach works.
-
Waverley Welding Company provides welding services for a variety of industrial customers in the manufacturing, aerospace, and electronics industries. The number of jobs completed from one month to...
-
Franklin Products Limited manufactures and distributes a number of products to retailers. One of these products, SuperStick, requires four kilograms of material 0236 in the manufacture of each unit....
-
Consider the logit model with \(\operatorname{Pr}\left[y=1 \mid x_{1}, x_{2} ight]=\Lambda\left(\beta_{0}+\beta_{1} x_{1 i}+\beta_{2} x_{2} ight)\), where \(\Lambda(z)=e^{z} /\left(1+e^{2} ight) x\)....
-
Suppose we use an index formulation for a discrete choice model but it is felt that the latent variable is strictly positive. This is accommodated by supposing that the latent variable \(y^{*}\) has...
-
Use the health expenditure data of Section 16.6. The model is a probit regression of DMED, an indicator variable for positive health expenditures, against just one regressor for simplicity, NDISEASE,...
Study smarter with the SolutionInn App