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...
-
Suppose that the UDP receiver computes the Internet checksum for the received UDP segment and finds that it matches the value carried in the checksum field. Can the receiver be absolutely certain...
-
Investing abroad has substantial individual asset risk. Why invest in it then?
-
(Portfolio statistics of two stocks) Calculate the average return and the variance of a portfolio composed of 30% of GM and 70% of Microsoft (MSFT) stocks, using the following data: 1. A B A...
-
Unrelated Business Income Tax. The Silverton Symphony Orchestra Hall is a well-established not-for-profit organization exempt under IRC Sec. 501 (c) (3) that owns a facility that is home to the local...
-
Hello I need some assistance. calculate the cost of credit usung the formulas show your calculations for simple interest. 1.if a person borrows $2,000 for car repairs and the interest rate is 5% and...
-
What are the triads using roman numerals and figured bass numbers for this excerpt? 30-3. Use Roman numerals and figured bass numbers to identify triads in these works. a. Schubert, "Death and the...
-
Ivanhoe Music Shop gives its customers coupons redeemable for a poster plus a Bo Diddley CD. One coupon is issued for each dollar of sales. On the surrender of 100 coupons and $6.00 cash, the poster...
-
What are herringbone gears? What is their advantages?
-
Compare the gross profit ratios of a number of different retailers. Are the differences very substantial? How do you explain or justify such differences?
-
The following data refer to a Hartnell governor: Length of ball arm of bell crank lever = 150 mm; length of sleeve arm = 100 mm; Mass of ball = 5 kg; spring stiffness = 250 N/mm. At minimum speed of...
-
What are crown and miter bevel gears?
-
The controlling force curve of a spring controlled governor is a straight line. The weight of each governor ball is 40 N and the extreme radii of rotation are 120 and 200 mm. The values of the...
-
Presented below is the trial balance of Your Company as of December 31, 2019. After the closing entries have been recorded, what is the ending balance for retained earnings? Account Title: Debit...
-
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....
-
Sole proprietorship, partnership, and corporation are the three principal forms of business organization. The advantages of the first two include the ease and low cost of formation. The advantages of...
-
Short-term rates are more volatile because (1) the Fed operates mainly in the short-term sector, hence Federal Reserve intervention has its major effect here, and (2) long-term rates reflect the...
-
The three primary determinants of a firm's cash flows are: (1) sales revenues; (2) operating expenses, such as raw materials costs and labor costs; and (3) the necessary investments in operating...
Study smarter with the SolutionInn App