![lebron06james](/avatars/31017.jpg)
lebron06james
03.04.2020 •
Business
Nicole Walker owns a small bakery in Georgia. A friend has asked to partner with her in the business. In order to know if she wants to expand the business, Nicole wants to "run" some computations to better understand the existing business. Budgeted data for the next 12 months includes:
Revenues $600,000
Fixed costs $150,000
Variable costs $425,000
Variable costs will change based on the number of products sold. Use an Excel spreadsheet to compute expected operating income for each of the following scenarios. Please refer to CSU-Global Library (Links to an external site.) for Lynda tutorials on using Microsoft Excel or use the Excel Tutorials link found in the classroom if you need assistance.
A. A 5% increase in contribution margin, but keeping revenues steady,
B. A 5% decrease in fixed costs,
C. A 10% increase in units sold,
D. A 15% increase in units sold and a 5% increase in fixed cost,
E. A 5% decrease in variable costs and a 5% decrease in fixed cost
Solved
Show answers
More tips
- F Food and Cooking The Most Delicious and Simple Fish in Batter Recipe...
- D Dating, Love, Relationships How Long Can Love Last?...
- A Auto and Moto Mastering One-Movement Parking: All You Need to Know...
- C Computers and Internet How to Properly Order Clothing from International Online Stores...
- H Health and Medicine Headache: A Comprehensive Guide to Treatment...
- F Family and Home How to Choose the Best Diapers for Your Baby?...
- A Auto and Moto Discovering the Leader: What is the Most Expensive Car in the World?...
- F Food and Cooking How to Quickly Put your Child to Sleep?...
- C Computers and Internet How to Create a Website for Free and Easy?...
- F Family and Home Parquet or laminate, which is better?...
Answers on questions: Business
- B Business Give an example of an economic activity from a traditional economy that is seen in today s market...
- B Business Which statement is true when recording the sale of goods for cash in a perpetual inventory system?...
- B Business Describe the influence of advanced technology, malpractice coverage, and expanded roles of the health care industry on increased health care costs....
- B Business Billie s Billiard Barn has seen its business slow down ever since Patti s Ping Pong Parlour opened up across the street. Since the opening of Patti s Ping Pong Parlour,...
- B Business 15 . Solving for the WACC The weighted average cost of capital (WACC) is used as the discount rate to evaluate various capital budgeting projects. However, it is important...
- B Business June s job at an advertising agency entails identifying and selecting media options based on research into the audience profiles of various media as well as scheduling...
- B Business Liliana needs to furnish her new apartment. She found all the items she wanted on the manufacturer s website and can save over $500 buying directly from the manufacturer....
- B Business Jeremy holds 14.5% shares of stock in an automobile company. As per the company norms, if the company issues new stock, as an existing stockholder, Jeremy can buy 14.5%...
- B Business You have determined you want to buy an advanced hybrid vehicle and a visit to ford s website has built a ford fusion hybrid se and uses hybrid fuel technology with the...
- B Business Thomas ski equipment receives an invoice for $10,000 worth of merchandise from one of its suppliers. the invoice has discount terms of 2/10, net/60. twenty days later,...
Ответ: