Create a model of this problem in google sheets

Assignment Help Managerial Accounting
Reference no: EM133003931

Boater Radio produces handheld VHF radios for boating enthusiasts who like to talk to other boats on the open water. It is scheduled to produce and sell 5,000 radios next month. It expects to record sales of $500,000, variable costs of $300,000 and ?xed costs of $135,000. It has received an offer from the Coast Guard to buy 1,000 radios if they can be delivered next month at a price of $75 per radio. The dif?culty is that Boater Radio can produce at most 5,500 radios in one month. Therefore it would have to cut back on its regular sales if it decides to accept the offer from the Coast Guard.

Problem 1: Create a model of this problem in Google Sheets

Problem 2: What is the result if the company accepts the offer?

Problem 3: How does it compare to the existing business?

Problem 4: Regardless of the result above, Boater does not really want to reduce existing sales so much. If they counter-offer to sell the Coast Guard 900 radios, what is the minimum price that they can charge so that their operatingpro?t will not decline?

Reference no: EM133003931

Questions Cloud

Describe organization of company top management team : How would you describe the organization of your company's top management team?
Valuation of stock depends on past dividends : Valuation of stock depends on past dividends?
Find the payback period for project : Find the Payback period for each project, The NPV for each project, the IRR for each project, and the incremental IRR.
How was change beneficial for the organisation : How was this change beneficial for the organisation and Recommendations Conclude your report explaining what you learned from this analysis
Create a model of this problem in google sheets : If they counter-offer to sell the Coast Guard 900 radios, what is the minimum price that they can charge so that their operatingpro?t will not decline?
Evaluate and analyse personal experience : Evaluate and analyse your personal experience for working in a group before, using a personal example, to establish positive and negatives of the experience
What thinking can sometimes lead to improved results : Keep in mind that having a different perspective or lens on what your developing in your own thinking can sometimes lead to improved results.
What is newsat euro cost of capital : Newsat Telco is planning on investing $40 billion in Europe this year for a satellite communications system. The expected cashflow over the next three years is
Calculating fees on a loan commitment : You have approached your local bank for a start-up loan commitment for $1,190,000 needed to open a car repair store. You have requested that the term of the lo

Reviews

Write a Review

Managerial Accounting Questions & Answers

  How much are the budgeted purchases for november

Sam's Toys budgeted sales of $300,000 for the month of November and cost of goods sold equal to 80% of sales. Beginning inventory for November was $50,000 and ending inventory for November is estimated at $55,000. How much are the budgeted purchases ..

  How many investors contributed

If the partnership raised $420,000, then how many investors contributed $5,000 and how many contributed $10,000

  Purchases for each month of the first quarter

Estimate cash disbursements related to purchases for each month of the first quarter of 2012.

  Make journal entries for the required consolidation data

Prepare journal entries for the required consolidation data adjustments on 30 June 2020. Charles Ltd gained control of Darwin Ltd by purchasing all its share.

  Asignacioacuten individual t2ai 1 cvpbep1 fixed costs are

asignacioacuten individual t2ai 1 cvpbep1. fixed costs are 1500000 and the contribution margin per unit is 150. what is

  List and describe in detail the seven tasks

You are a salesperson for Proctor and gamble selling Tide detergent. List and describe in detail the seven tasks that you or any other salesperson must perform in your profession.

  How do determine the amount of overhead to be allocated

How do determine the amount of overhead to be allocated to each type of product using labor hours as the allocation base. Assume 60,000 labor hours

  What steps involved in process for capital decision-making

What are the steps involved in the process for capital decision-making? Which table will help you determine the value of your account at the end of 12 years?

  Explain the major differences between job order

Explain the major differences between job order and process costing systems.

  Calculate the opportunity loss of producing chairs

Calculate the opportunity loss of producing 12,000 chairs in 2017 compared to the capacity utilization alternatives: theoretical, practical, and denominator.

  How the corporation could earn above-average returns

Please explain how using the industrial organization model and the resource-based model will help determine how the corporation could earn above-average returns

  Determine the number of units that agro engine company sell

Determine the number of units that Agro Engine Company must sell (a) to break even and (b) to achieve its net income objective

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd