Margaret Williams, production manager at Williams Manufacturing, finds her profits at $15,000 inadequate for her business. The bank is insisting on an improved profit picture prior to an approval of a loan for some new equipment. Margaret would like to improve the profit line to $25,000 so she can obtain the approval for the loan. Given the information below and using a Sales Strategy, what percentage change of sales would need to be increased to achieve a $25,000 profit? FACTOR Sales Cost of Supply Chain Purchases Production Costs Fixed Costs Profit Percentage 100% 70% 12% 12% 6% Current Situation $250,000 $175,000 $30,000 $30,000 $15,000

Margaret Williams, production manager at Williams Manufacturing, finds her profits at $15,000 inadequate for her business. The bank is insisting on an improved profit picture prior to an approval of a loan for some new equipment. Margaret would like to improve the profit line to $25,000 so she can obtain the approval for the loan. Given the information below and using a Sales Strategy, what percentage change of sales would need to be increased to achieve a $25,000 profit? FACTOR Sales Cost of Supply Chain Purchases Production Costs Fixed Costs Profit Percentage 100% 70% 12% 12% 6% Current Situation $250,000 $175,000 $30,000 $30,000 $15,000

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

an Shields Communications, Inc., a cellular communications provider based in Michigan, charges $86 per month for an all you can talk service plan. The company plans to increase marketing expenditure next year, but wants to determine the current CLV before making this decision. Variable costs before marketing are $28 per account per month and monthly retention expenditures are $12 per account. Ian Shields Communication's annual attrition rate is 17%, with an annual discount rate of 15%.
You have performed preliminary analytical procedureson one of your audit engagements and observed the following independent situations:1. The allowance for obsolete inventory increased from the prior year, but the allowance as a percentage of inventory decreased from the prior year.2. Long-term debt increased from the prior year, but total interest expense decreasedas a percentage of long-term debt.3. The dollar amount of operating income is consistent with the prior year althoughthe entity was more profitable on a net income basis.4. The quick ratio decreased from the prior year, although the amount of cash and netaccounts receivable is almost the same as the prior year.Below are possible explanations for each of the observed changes in the financial statementamounts and ratios. For each observed change, select the most likely explanation(s)from the list below. Note: There may be more than one explanation for a given observedchange, and an explanation can be used more than once.a.…
1. Descriptive analysis: What are the profitability benefits for Apple to engage in the following Short Term Business Decisions: a. Make or Buy b. Keep or Replace c. Accept or Reject Special Sales order
To find the net present values of future cash flows for six different discounted rate of interest, use: a. Data Table b. Goal Seek c. None of these d. Scenario manager
Mavis and John have joined forces to start M&J Food Products, a processor of packaged shredded lettuce for institutional use. John has years of food processing experience, and Mavis has extensive commercial food preparation experience. The process will consist of opening crates of lettuce and then sorting, washing, slicing, preserving, and finally packaging the prepared lettuce. Together, with help from vendors, they think they can adequately estimate demand, fixed costs, revenues, and variable cost per 5-pound bag of lettuce. They think a largely manual process will have monthly fixed cost of $50,000and a variable cost of $2.50 per bag. They expect to sell 75,000 bags of lettuce per month. They expect to sell the shredded lettuce for $3.25 per 5-pound bag. John and Mavis has been contacted by a vendor to consider a more mechanized process. This new process will have monthly fixed cost of $125,000 per month with a variable cost of $1.75 per bag. Based on the above scenario: Should…
Income taxes have the effect of Select one : a decreasing the cost of capital for the firm. B. None of these c. decreasing the cost of debt. D. increasing the cost of debt
- Please explain two characteristics of the maximum of minimum profits criterion (Maximin method)
If Tyson’s contribution margin is 30 per cent on thisproduct, what increase in sales will it need to breakeven on the increase in fixed costs to hire the new salesreps?
Why is it important to project the first-year financial performance on a monthly basis and the subsequent yearly budgets, on a quarterly basis? Explain.
Hi, help me with providing essay questions for basic terms in income statement?
ro forma income statement. Given the income statement , for California Cement Company for 2013 and an expected sales growth rate of 6.67% for 2014, prepare a pro forma income statement for 2014. First, find the percentage of each income statement line from 2013 as a percent of sales. (Round to three decimal places.) California Cement Company Income Statement for 2013 Sales revenue $ 22,869,000 Cost of goods sold $ -11,637,000 Selling, general, and administrative expenses $ -3,993,000 Depreciation expenses $ -1,331,000 EBIT $ 5,908,000 Interest expense $ -175,000 Taxable income $ 5,733,000 Taxes $ -2,512,462 Net income $ 3,220,538 What is the sales forecast for 2014? (Round to the nearest dollar.) The pro forma income statement for 2014 is: (Round to the nearest dollar.) California Cement Company Pro Forma Income Statement for 2014 Sales revenue $ ? 100.00% Cost of goods sold $ ? 50.885 %…
Kamal Fate production manager of Kennesaw Manufacturing, finds his profit at $26,400 (as shown in the statement below) inadequate for expanding his business. The bank is insisting on an improved profit picture prior to approval of a loan for some new equipment Kamal would like to improve profit line to $36,400 so he can obtain the bank's approval for the loan Sales Cost of supply chan purchases Other production costs 240,000 163,200 Faxed costs Prof % of sales 100% 68% 10% 11% 11% 24,000 26,400 26,400 a) What percentage improvement is needed in a supply chain strategy for profit to improve to $36 400? What is the cost of material with a $36,400 profit? A decrease of in supply chain costs is required to yield a prott of $36,400, for a new cost of supply chain purchases of $ (Enter your response for the percentage decrease to one decimal place and enter your response for the new supply chain cost as a whole number) O