Q1) One of the industrial investors needed an analysis that would lead him to a break-even level between the following inputs and outputs: Fixed Cost = 180079 $ ,Variable Costs = 47$ , Revenue of saling prices per unit (204 $ ) Y of Products 890 899 917 944 956 975 985 1,147 1,159 1,193 1,209 1,288 Required: A) Find all lines of anlysis. B) How the produaction reach to B.E.P. C) Based on the available information, show the level of variation from line of production to other annually.

Q1) One of the industrial investors needed an analysis that would lead him to a break-even level between the following inputs and outputs: Fixed Cost = 180079 $ ,Variable Costs = 47$ , Revenue of saling prices per unit (204 $ ) Y of Products 890 899 917 944 956 975 985 1,147 1,159 1,193 1,209 1,288 Required: A) Find all lines of anlysis. B) How the produaction reach to B.E.P. C) Based on the available information, show the level of variation from line of production to other annually.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

2. Perform an ABC analysis for the data provided. Clearly explain why you classified items as A, B, or C. Annual Unit Item Usage 2400 Cost $19.51 $32.60 $10.20 $6.80 2 6200 3 8500 4 3200 6000 $4.50 $55.70 $3.60 $44.90 $35.62 750 7 8200 8 9000 5800 10 820 $82.60 $40.50 11 500 12 2000 $15.40 $14.60 $35.80 13 2400 14 6300 15 4750 $17.30 2700 $51.75 $42.90 $25.30 16 17 1600 18 1350 19 5000 $67.00 20 1000 $125.00
Required: A. What are the actual and budgeted selling prices? What are the actual and budgeted variable costs per unit?B. Calculate all the required variances and present the variance analysis report.
28. 4.4 The Gorman Manufacturing Company must decide whether to purchase a component part from a supplier or to manufacture the component at its own plant. If demand is high, it would be to Gorman's advantage to manufacture the component. If demand is low, however, Gorman's unit manufacturing cost will be high because of underutilization of equipment. The projected profit in thousands of dollars for Gorman's make-or-buy decision is as follows. Demand Medium $40 $45 Decision Manufacture component Purchase component a. Determine the best decisions using the maximax, maximin, and opportunity loss decision criteria. b. Assume that the probability of low demand is 0.35, of medium demand is 0.35, and of high demand is 0.30. What is the best decision using the expected value criterion and what is the expected value of perfect information? Low $220 $210 High $100 $70
Consider the following price and dividend data for Ford Motor Company: Dividend ($) Date December 31, 2004 January 26, 2005 April 28, 2005 July 29, 2005 October 28, 2005 December 30, 2005 Price ($) $14.04 $13.43 $9.14 OA. -44.4% OB. -40.2% OC.-42.32% OD. -38.1% $10.74 $8.02 $7.72 $0.12 $0.12 $0.12 $0.12 Assume that you purchased Ford Motor Company stock at the closing price on December 31, 2004 and sold it at the closing price on December 30, 2005. Your realized annual return is for the year 2005 is closest to:
If Exxon uses FIFO for its inventory valuation, calculate the cost of ending inventory and cost of goods sold if ending inventory is 110 barrels of crude oil. Beginning inventory and purchases Barrels Barrel cost Total cost Beginning inventory: Jan 1 129 $ 96 $ 12,384 March 1 54 102 5,508 June 1 69 99 6,831 September 1 79 91 7,189 December 1 54 104 5,616 385 $ 37,528 Cost of ending inventory Cost of goods sold
1. You are starting a business selling ferrets. • You need a pen and supplies which will cost you $100. Also, each ferret costs $10 each. Fill the table for cost. You will sell the ferrets for $15 each. Fill the table for Money. Plot and graph both lines for Cost and Money Use the provided paper (looks like this), take a picture and submit. 400 Money ($) Cost 0. 10 10 200 20 20 30 30 40 40 50 50 10 20 30 40 50 Edit View Insert Format Tools Table 12pt v Paragraph v BIUA v 8888- Ferrets Bought 888- Ferrets sold Money ($)
It might be sensible for a company to benchmark each of its sales reps against: O its other sales reps competitors sales reps sales reps of a firm in a different industry all of the above are true QUESTION 2 Capital sources include: O profits loans stocks all of the above QUESTION 3 The most useful brejakdown of data in a sales analysis is by: O product, package size, grade, or color O customer type geographic region any or all of the above depending on the situation QUESTION 4 Which of the following is NOT a way to stimulate profit growth? O do a better job of holding onto customers
11.4 Given the following data, calculate the average demand and the standard deviation. Period 1 2 3 st 4 5 67 8 9 10 Total Actual Demand 1700 2100 1900 2200 2000 1800 2100 2300 2100 1800 Deviation Deviation Squared
Find the Given Payoff table and use Minimax regret to evaluate best decisions. Demand Moderate 22 27 21 Decision Small Warehouse Medium -1 Warehouse Large Warehouse -5 Medium Warehouse Data inadequate Small Warehouse Low 24 Large Warehouse High 23 33 39
As purchasing agent for Eynan Enterprises in Richmond, Virginia, you ask your buyer to provide you with a ranking of "excellent," "good," "fair," or " poor" for a variety of characteristics for two potential vendors. You suggest that the "Products" total beweighted 40% and the other three categories totals be weighted 20% ueach. The buyer has returned the ran kings shown in TableS 11 .2. Which of the two vendors would you select?
1. An electronics component manufacturer produces high precision assemblies for the aeronautics and space industry, controls for kitchen appliances, and some items for industrial equipment. Company's purchased parts are given in the following table. Product No 575 607 625 811 947 024 413 483 Unit Cost ($) Annual Volume (units) 3,200 2,500 93.00 31.00 212.00 130.00 618.00 720.00 0.25 0.60 320 475 300 300 25,000 6,800 Product No 495 211 273 435 825 661 893 Unit Cost ($) 1.25 6.30 75.00 63.00 84.00 1.00 485.00 Annual Volume (units) 15,000 3,000 3,000 450 30 4,000 65 Classify the company's purchased parts according to ABC principles. (b) Create an exchange curve for this population of inventoried items. (c) Suppose that the company is operating with a total cycle of $70,000 and 24 numbers of orders. Comment this operating system. (a)
Franklin Company makes fine jewelry that it sells to department stores throughout the United States. Franklin is trying to decide which of the two bracelets to manufacture. Cost data pertaining to the two choices follow. Bracelet A Bracelet B Cost of materials per unit Cost of labor per unit Advertising cost per year Annual depreciation on existing equipment %24 30 37 43 43 8,800 6,500 7,700 5,900 Required a. Identify the fixed costs and determine the amount of fixed cost for each product. b. Identify the variable costs and determine the amount of variable cost per unit for each product. c. Identify the avoidable costs and determine the amount of avoidable cost for each product.