Question: i need the answer in excel sheet and the steps The following is yearly information on two main sources for the company profit: Row material

i need the answer in excel sheet and the steps

The following is yearly information on two main sources for the company profit: Row material Labor cost Unit made Demand cost PRODUCT A $30 $100 3000 1850 PRODUCT B $45 $78 2500 2100 price 250 170 The fixed cost is estimated to be $1000 annually. Based on the above information find the following: 1. The company yearly profit 2- Use goal seek to find the following a. At what PRODUCT B demand both products will generate the same revenue? b. How much they should produce from each Product A and B, to reach a profit of $500,00, if the demand of them is equal to 75 of the production and Product A should be 50% of Product B. 3. If the company will sell the same amount from Product A and Product B which represents 65% for Product A and 76% for Production B, how much they should produce from both the get profit of $750,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

The following is yearly information on two main sources for the company profit: Row material Labor cost Unit made Demand cost PRODUCT A PRODUCT B $30 $45 $100 $78 The fixed cost is estimated to be...

Please Answer in Excel and SHow all Steps X AFF 210 Problem Set TWO Winter 2022 PROBLEM ONE (20 MARKS) Sales Cost of Goods Sold Selling and Administrative Expenses Advertising Expenses Depreciation...

Board CHAPTER 1 Economics: Foundations and Models n this book, we use economics to answer questions such as the following What determines the prices of goods and services from bottled water to smart...

Looking for help on Capsim Final Performance Assessment Report For Company ERIE? "- OVERALL (BUSINESS LEVEL) STRATEGY OVERALL COMPANY PERFORMANCE (2-3 pages)" Andrews ROS 16.2% Asset Turnover 1.16...

uestion: 1. IN A STOCK ACQUISITION ACCOUNTED FOR BY THE EQUITY METHOD, A PORTION OF THE PURCHASE PRICE OFTEN IS ATTRIBUTABLE TO GOODWILL OR TO SPECIFIC ASSETS OR LIABILITIES. HOW OR UNDER WHAT BASIS...

Case Analysis read the two cases below words :500 The topic of this paper is Operations Management and Value creation: Lessons from cases. Summarize both cases (Roche and Atlantic Animal Hosptial)...

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

CableTech Bell Corporation (CTB) operates in the telecommunications industry. CTB has two divisions: the Phone Division and the Cable Service Division. The Phone Division manufactures telephones in...

I would like someone to double check the work that has been done on this project. I have attached the Excel spreadsheet that we have completed which shows the subsequent tabs for each step. I have...

Question (1) - 30 points 1.1-Follow the steps explained in class 13-adjusted Forecasting and calculate a sales forecast for product Asese in the high Tech segment in 2024 (show the difference between...

A narrative essay is a story that makes a point It is used in the following ways to show or describe personal evidence of something, to teach a lesson, to illustrate a point or an idea, or to make...

The table below presents the tax revenue and spending for the government over five years. Government Revenue and Spending Year Tax Revenue (billions of dollars) Spending (billions of dollars) Budget...

Gamani Ltd ensures that its financial statements adhere to Generally Accepted Accounting Principles ( GAAP ) . One of these principles is the "Consistency Principle." How does the principle benefit...

Hypothesis Testing of a Single Mean LCTCS Tuition: Louisiana Community And Technical College System consist of 2 community colleges across the state. I think RPCC's tuition and fees is lower than the...

2-8 Fulbert Timber Merchants in Brixton, UK features a large selection of building supplies, including timber, fencing and decking, mouldings, hardwood flooring, sheet materials, windows, doors,...

2-7 Use the Time/Space Collaboration and Social Tool Matrix to classify the collaboration and social technologies used by BASF..

2-6 Identify the steps that are performed in the process of selecting and checking out a book from your college library and the information that flows among these activities. Diagram the process. Are...