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...
-
Information related to Bryant Limited is presented below for its first month of operations Post the above transactions individually to the accounts receivable subsidiary ledger for each customer, and...
-
Phelps plc leases a building to Walsh Ltd. on January 1, 2022. The following facts pertain to the lease agreement. 1. The lease term is 5 years, with equal annual rental payments of 4,703 at the...
-
Identify the two ways that trial material may be organized. What are the advantages and disadvantages of each method?
-
Refer to the data in the previous problem for Peterson Pipes. Peterson expects its first-quarter opening balances in cash, accounts receivable, and accounts payable to be $75,000, $125,000, and...
-
Ch 5 In thinking about the VRIO framework, which of those letters could be used to explain a situation where a company has repeated failures, and they never seem to learn from the failures, let alone...
-
The Atiwa forest is rich in bauxite. The resources could be harnessed to support development in the country. The government of Ghana has signed a batter deal with the Republic of China. In this deal,...
-
Calculate the following: 27 b. Store these two matrices: 946 - 10 20 30 40 [50 60] [3] A 2 B=4 [8] Which of the following multiplications are possible? For those that are, compute the result. i. A-B...
-
Mr Burns' new consulting firm offers insights to clients regarding nuclear power plant. The service fee is $57,000, paid at the start of the year and has 350 clients. The company spends $28,500 on...
-
S c) Describe the average-case performance of the linear search algorithm in Figure 1 in terms of the average number of comparisons used, assuming that the integer x is not in the list. Use step by...
-
You receive an invoice dated September 21, 2009 in the amount of $1500 with terms of 2/15 net 30. If you pay $500 toward the invoice on September 30, what is the amount that is credited and what do...
-
An object moves in a circular motion that is not uniform. The c rclude it describes has a radius of 1 2 meters. The speed of the object is given by in = 3 . 6 + 1 . 5 ???? 2 with in in meters per...
-
11) a) Are the following row vectors linearly independent or linearly dependent? Why? [110], [100], [111] (5 points) b) Find the rank for the following matrix: 1
-
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....
-
We have a flash drum separating \(50.0 \mathrm{kmol} / \mathrm{h}\) of a mixture of ethane, isobutane, = and n-butane. The ratio of isobutane to n-butane is held constant at 0.80 (that is, Zic4/ZnC4...
-
A ternary mixture of methanol, n-propanol, and n-butanol is flash distilled at a pressure of \(0.74 \mathrm{~atm}\). The feed is \(36 \mathrm{~mol} \%\) methanol, \(42 \mathrm{~mol} \%...
-
We flash distill a mixture of methane and n-butane at \(\mathrm{p}_{\text {drum }}=6.0\) bar. a. Use the DePriester charts or Eq. (2-28). For several temperatures from \(\mathrm{T}=\) \(-60^{\circ}...
Study smarter with the SolutionInn App