A1 2 B fx Function: MAX; Formulas: Subtract, Divide, Cell E C F BES.7-Using Excel to Determine Profitability Given a Constrained Resource 4 PROBLEM 5 Rachel wants to use her knitting skills to make a little extra money so she can 6 enjoy a theatre weekend with her besties. She's got the pattern down for a 7 hat, scarf, and mittens, but she realizes that her available time is limited. She 8 should be able to sell as many of any item as she can make, but she wants to 9 make sure she's making the best use of her time. Cost and time information. 10 are provided here. 11 12 13 14 15 16 17 Time in minutes Cost of yarn per unit Selling price per unit $ D Hat Scarf 20 30 4.00 $6.00 $ 15.00 15.00 Mittens 40 4.00 15.00 G H Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Calculate the contribution margin per unit of the scarce resource for each item. Contribution margin per unit of scarce resource Hat The highest CM is Scarf Mittens Which item should Rachel focus on in order to maximize her profitability and resources? N

A1 2 B fx Function: MAX; Formulas: Subtract, Divide, Cell E C F BES.7-Using Excel to Determine Profitability Given a Constrained Resource 4 PROBLEM 5 Rachel wants to use her knitting skills to make a little extra money so she can 6 enjoy a theatre weekend with her besties. She's got the pattern down for a 7 hat, scarf, and mittens, but she realizes that her available time is limited. She 8 should be able to sell as many of any item as she can make, but she wants to 9 make sure she's making the best use of her time. Cost and time information. 10 are provided here. 11 12 13 14 15 16 17 Time in minutes Cost of yarn per unit Selling price per unit $ D Hat Scarf 20 30 4.00 $6.00 $ 15.00 15.00 Mittens 40 4.00 15.00 G H Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Calculate the contribution margin per unit of the scarce resource for each item. Contribution margin per unit of scarce resource Hat The highest CM is Scarf Mittens Which item should Rachel focus on in order to maximize her profitability and resources? N

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

es A jeans maker is designing a new line of jeans called Slims. The jeans will sell for $290 per pair and cost $182.70 per pair in variable costs to make. (Round your answers to 2 decimal places.) (1) Compute the contribution margin per pair. Contribution margin (2) Compute the contribution margin ratio. Choose Numerator: Choose Denominator: = Contribution Margin Ratio Contribution margin ratio = G Check n
The ingredients for your braised greens cost $1.32. You sell it for $4. What is your contribution margin? Select one: a. $3.18 b. $4 C. 0.31 d. $2.68
part 2. Imogen, the brand manager for ‘Skinsoft’, was reviewing price and promotion alternatives for her brand. She wanted to increase market share, but was unsure whether she should ask for an increase in advertising budget or consider a price promotion. The current volume, price, and cost summary for ‘Skinsoft’ follows: Skinsoft Unit Price £2.00 Unit Variable Cost £1.40 Unit Volume 1,000,000 Imogen thought she might be able to negotiate with her boss and secure either a temporary 10 percent price reduction, or an investment of an incremental £150,000 in advertising. a. What absolute increase in unit sales and revenue would be necessary to recoup the incremental increase in advertising expenditure? b. What increase in absolute unit sales and revenue would be necessary to maintain the level of total contribution if the price is reduced by 10 percent? c. Which alternative would you recommend to Imogen? Explain your choice.
Please show proper step by step calculation Go Fly A Kite is considering making and selling custom kites in two sizes. The small kites would be priced at $10.50 and the large kites would be $23.50. The variable cost per unit is $5.05 and $11.10, respectively. Jill, the owner, feels that she can sell 2,600 of the small kites and 1,700 of the large kites each year. The fixed costs would be $2,100 a year and the depreciation expense is $900. The tax rate is 21 percent. What is the annual operating cash flow?
A jeans maker is designing a new line of jeans called Slams. Slams will sell for $320 per unit and cost $220.80 per unit in variable costs to make. Fixed costs total $65,500. (Round your answers to 2 decimal places.) 1. Compute the contribution margin per unit. Contribution margin 2. Compute the contribution margin ratio. Numerator: Denominator: Contribution Margin Ratio %3D Contribution margin ratio %3D 3. Compute income if 6,100 units are produced and sold Income
ngageNOWv2| Online teachin x takeAssignment/takeAssignmentMain.do?invoker%-&takeAssignmentSessionLocator%=&inprogress%3false く☆ eBook 2. What if FlashKick added a third line-tournament quality soccer balls that were expected to take 40 percent of the units sold of the match balls and would have a selling price of $42 each in January and February, and $45 each in March? Prepare a sales budget for FlashKick for the first three months of the coming year. Show total sales for each product line by month and in total for the first quarter. If required, round your answers to the nearest cent. FlashKick Company Sales Budget For the First Quarter January February March Quarter Practice ball: Units 50,000 V 58,000 V 80,000 V 188,000 V Unit price 8.25 V $ 8.25 V 8.25 V $ 8.25 Sales 412,500 V$ 478,500 V 660,000 V 1,551,000 V Match ball: Units 4,200 4,500 V 7,800 V 16,500 15 V 15 V $ 15 V 15 V Unit price 67,500 V $ 117,000 V 247,500 V Sales $ 63,000 V Tournament ball: 5,200 V 11,000 V 2,800 3,000…
Pink has the below data. Determine the WACM %. Your answer should be to the nearest decimal point, for example, 45.2 Budget Clothes Hats Shoes Total Sales 2 500 1 500 3 000 7 000 Variable Costs 1 200 600 1 700 3 500 Contribution Margin 1 300 900 1 300 3 500 Fixed Costs Profit 3 000 500
le Chrome tempt.php?attempt%3D1893307&cmid%3891193&page=10 SYSTEM (ACADEMIC) Time left Company XYZ is producing and selling 2,500. At this level, the selling price per unit is $10, the variable expenses per unit is $7, and fixed expenses are $1,500.How much is the profit? O a. $13,500 O b. $8,500 О с. $411,000 d. $6,000 O e. $16,000 AGE NEXT PA - a 40) ENG rch ort sc delete home 40 num % + backspace lock R enter esned
a. How many pupils do Hannah and Kathleen need to enrell in their class to break even? Contribution Margin per unit = Sales per price-Variable Cost per unit 3D75-12 = 63 per unit %3D Break-even Volume Fixed Cost/Contribution Margin per unit =D1,700/63 per unit %3D = 26.98 or 27 pupils %3D b. If Hannah and Kathleen want to make a profit of $5,000 for the summer, how many pupils do they need to enroll? Pupils need to be enrolled = Fixed Cost + Desired Profit Contribution Margin per unit 1.700 + 5,000/63 per unit 106.3 or 107pupils c. Hannah and Kathleen estimate that they might not be able to enrolI more than 60 pupils. If they enroll this many pupils, how much would they need to charge per pupil in order to realize their profit goal of $5,0007
• Assume you run a bakery and you sell tarts. Below are the monthly data # tarts sold | total costs Jan 500 $500 Feb 350 $430 Mar 380 $470 Apr 540 $560 May 310 $320 Jun 360 $450 a) Estimate the fixed cost and variable cost using the high-low method. b) What are the fixed cost and variable cost using the Regression method? What is the R square? In this example, can you give ONE potential explanation why R square is not 1?
Most Visited Getting Started Getting Jumpy With... Bash Bunny Docum.... GitHub - hak5/bash... Bunny Toolkit - Home Alice's company has a machine that can produce a maximum of 2722 components annually. She sells each component for $65. The company's fixed costs are $35,120 per annum, and the variable costs are $25 per component. a) Calculate the number of components the company needs to sell per annum to break-even. components b) Calculate the break-even in dollars (round off to the nearest cent). $ c) Calculate the break-even as a percent of capacity (round off to the nearest percent). % d) If Alice produced and sold 1047 components in a year, what was the profit made or loss incurred? O profit loss e) if the company wants to make a profit of $69,000 per year, how many components does it need to sell? components Reset Wifi Pineappl... Initial Setur
ndow Help nework.pdf Aa v 100000 38%= 38,000 Question 4. Dawn is preparing a budget for her operation. She has forecasted revenue of $1,200,000 for th budget period and now wants to complete the variable expense portion of her forecast. Dawn reviewed her historical cost percentage records. She then established her target variable cost percentages for several variable cost categories. Use Dawn's target cost percentages to comple her variable expense forecast and then answer the questions that follow. Revenue Forecast: $1,200,000 Historical Variable Expense Cost Variable Target Expense Percentage Expense Percentage 2.8% Еxpense Forecast Marketing 3.0% 36,000 Glassware 0.25 0.15 1,800 Paper products 0.25 0,25 3,000 Linens 1.0 0.75 9,000 Flowers and decorations Kitchen utensils 0,50 0.25 3,000 0.25 0.25 3,000 1. What is the amount Dawn will budget for marketing? 2. What is the amount Dawn will budget for linens? 3. What is the amount Dawn will budget for kitchen utensils? 4. What would be…