Question

In: Accounting

Managerial Decision Making Model Short Answer Something's wrong! Generator X Company produces two generators. The Excel...

Managerial Decision Making Model Short Answer Something's wrong! Generator X Company produces two generators. The Excel has been manufactured for more than 20 years and it sells for $900. The Power is a new model developed and marketed approximately two years ago. It sells for $1,140. Based on the information in the company's income statement for 2020, upper management wants to downscale the spend available marketing dollars on the Power while beginning to phase out the production of the Excel. Generator X Company Income Statement For the year ended December 31, 2020 Power Excel Total Sales $4,560,000 $19,800,000 $24,360,000 Cost of Goods Sold 3192000 12540000 15732000 Gross Profit 1368000 7260000 8628000 Selling & Administrative expenses $978,000 $5,830,000 $6,808,000 Net Income 390000 1430000 1820000 Units Produced and sold 4000 22000 Net Income per unit sold $97.5 $65 The standard Unit Costs of the Power and Excel Generators Power Excel Direct Material $584 $208 Direct Labor Power ($3.5 hr * $12) 42 Excel ($1.5 hr * $12) 18 Machine Usage Power (4 hr * $18) 72 Excel (8 hr * $18) 144 Manufacturing Overhead* 100 200 Total Standard Cost $798 $570 *Manufacturing overhead was applied on the basis of the machine hours at the predetermined rate of $25 per hour. Note: We have learned that direct costs inlcude direct materials and direct labor. For our purposes in this problem, you should also assume that Machine usage is a direct cost. Wait a minute!...before we do anything rash: Generator X's controller (Western New England MSA graduate) wants to try one more thing. She instructs her accountants to gather relative information so that her department may try allocating manufacturing overhead using activity-based costing and activity-based management. The following info was gathered: Activity Center Cost Driver Traceable Cost Number of Events / Activities Power Excel Total Soldering # of solder joints $942,000 385000 1185000 1570000 Shipments # of shipments 860000 3800 16200 20000 Quality control # of inspections 1240000 21300 56200 77500 Purchase Orders # of orders 950400 109980 80100 190080 Machine Power machine hours 57600 16000 176000 192000 machine setups # of setups 750000 14000 16000 30000 Total traceable costs $4,800,000 You will write a summary memo, that includes an executive summary, and responds individually to the following questions: Note: use excel as appropriate and show the tables in your responses. Question Point Value 1. What is the problem to be solved? 2. Identify the relevant information needed to solve this problem 3. List the necessary steps to solve this problem. 4. What are the alternative methods commonly utilized to allocate manufacturing overhead costs to product? How are they different? Which method might be better in this situation? 5. Using excel, recalculate the cost of these products. Using excel, recalculate the profit for each of these products. Present the calculations in the Income Statement format initially shown. Show calculations in total as well as on a per unit basis. Should Generator X Company stop product of the Excel Generator? Justify/explain your decision. Remember, you will write a summary memo, that includes an executive summary, and responds individually to the questions listed above.

Solutions

Expert Solution

as per our companies answering policy, we can answer only 4 sub-questions at a time. I'm providing you the answers for the most relevant 4 i.e (1,2,3,5) questions; kindly refer to the answering policy; thanks!


Related Solutions

Describe the Functional Model of Decision Making. Pick two of the steps in the decision making...
Describe the Functional Model of Decision Making. Pick two of the steps in the decision making process and describe how leaving them out might negatively affect a decision.
Managerial Decision Making Research and Analysis Focus of the Final Paper Research a specific company of...
Managerial Decision Making Research and Analysis Focus of the Final Paper Research a specific company of your choice and identify some of the managerial decisions that were made over time and in response to changes in its market or competitive environment. Use the Ashford University Library and web-based sources for your research. At least three external scholarly sources must be used in addition to the textbook. Address all of the following areas: Describe the company and provide a brief history...
Create a model and use Excel Solver to answer the following: A computer company manufactures two...
Create a model and use Excel Solver to answer the following: A computer company manufactures two types of computers. Each type of computer will require assembly time, inspection time, and storage space. The amounts of each of these resources that can be devoted to the production of the computers is limited. The manager wants to determine the quantity of each computer to produce to maximize the profit generated by sales of these computers. In order to develop a suitable model...
A generator at a utility company produces 100 A of current at 4.0 x 103 V....
A generator at a utility company produces 100 A of current at 4.0 x 103 V. The voltage is stepped up to 2.4 x 105 V by a transformer before being sent on a high voltage line across a rural area to a city. Assume the effective resistance of the line is 30.0 Ω and the transformers are ideal. a. Determine the percentage of power lost in the transmission line. b. What percentage would be lost if the voltage would...
A manufacturing company produces two models of an HDTV per week, x units of model A...
A manufacturing company produces two models of an HDTV per week, x units of model A and y units of model B at a cost (in dollars) of f (x, y) =(8x^2+8y^2)/4 . If it is necessary (because of shipping considerations) that4x + 5y = 20 , how many of each type of set should be manufactured peer week to minimize cost? What is the minimum cost?
List the steps in the model of rational decision-making. Discuss your answer from the marketer's lens...
List the steps in the model of rational decision-making. Discuss your answer from the marketer's lens and suggest some facilitating strategies to smoothen the consumer decision making.
Answer the two questions below in Excel using the WAAC Model. 1. You are considering a...
Answer the two questions below in Excel using the WAAC Model. 1. You are considering a pair of GICs (guaranteed investment contracts) o§ered by two di§erent life insurance companies. Each promises a single payment 10 years from now. (a) US Life Insurance Companyís GIC promises to pay 6.5% per annum and can be purchased today for $100,000. (b) Met Lifeís GIC promises to pay 5.7% per annum compounded monthly and can be purchased today for $95,000. Which would you buy?...
Kane Manufacturing has a division that produces two models of fireplace grates, x units of model...
Kane Manufacturing has a division that produces two models of fireplace grates, x units of model A and y units of model B. To produce each model A grate requires 3 lb of cast iron and 6 min of labor. To produce each model B grate requires 4 lb of cast iron and 3 min of labor. The profit for each model A grate is $2.00, and the profit for each model B grate is $3.00. Also, 1000 lb of...
what management of Steve Jobs(apple company) use, i.e. managerial role/skills, decision-making,communications,HRM,motivation and leadership) Also, how did...
what management of Steve Jobs(apple company) use, i.e. managerial role/skills, decision-making,communications,HRM,motivation and leadership) Also, how did Steve Jobs is a good leader/manager?
Ramsey Company produces speakers (Model A and Model B). Both products pass through two producing departments....
Ramsey Company produces speakers (Model A and Model B). Both products pass through two producing departments. Model A's production is much more labor-intensive than that of Model B. Model B is also the more popular of the two speakers. The following data has been gathered for the two products: Product Data Model A Model B Units produced per year 10,000 100,000 Prime costs $153,000 $1,530,000 Direct labor hours 143,000 310,000 Machine hours 21,000 196,000 Production runs 40 60 Inspection hours...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT