Required:1. Prepare a differential analysis as of June 19 to determine whether to promote tennis shoes (Alternative 1) or walking shoes (Alternative 2). If an amount is zero, enter "0". Use a minus sign to indicate costs. Ifrequired, use a minus sign to indicate a loss.Differential AnalysisPromote Tennis Shoes (Alt. 1) or Promote Walking Shoes (Alt. 2)June 19PromotePromoteDifferentialWalking Shoes(Alternative 1) (Alternative 2) (Alternative 2)Tennis ShoesEffectsRevenuesCosts:Direct materialsDirect laborVariable factory overheadVariable selling expensesSales promotionProfit (loss)$2. Determine whether to promote tennis shoes (Alternative 1) or walking shoes (Alternative 2).3. The sales manager had tentatively decided to promote walking shoes, estimating that operating income would be increased by $153,000 ($14 operating income per unit for 24,000 units, less promotion expensesof $183,000). The manager also believed that the selection of tennis shoes would reduce operating income by, $78,000 ($9 operating income per unit for 29,000 units, less promotion expenses of $183,000). Statebriefly your reasons for supporting or opposing the tentative decision.The sales manager's tentative decision should beThe sales managerconsidered the full unit costs instead of the differential (additional) revenue and differential(additional) costs. An analysis similar to that presented in part (1) would lead to the selection offor the promotional campaign, because this alternative will contributetooperating income than would be contributed by promoting Differential Analysis for Sales Promotion ProposalSole Mates Inc. is planning a one-month campaign for July to promote sales of one of its two shoe products. A total of $183,000 has been budgeted for advertising, contests, redeemable coupons, and otherpromotional activities. The following data have been assembled for their possible usefulness in deciding which of the products to select for the campaign:TennisWalkingShoesShoesUnit selling price$69$76Unit production costs:Direct materials$(12)$(16)Direct labor(4)(5)Variable factory overhead(3)(4)Fixed factory overhead(7)(9)Total unit production costs$(26)$(34)Unit variable selling expenses(22)(20)Unit fixed selling expenses(12)(8)Total unit costs$(60)$(62)Operating income per unit$9$14No increase in facilities would be necessary to produce and sell the increased output. It is anticipated that 29,000 additional units of tennis shoes or 24,000 additional units of walking shoes could be sold withoutchanging the unit selling price of either product.Required:1. Prepare a differential analysis as of June 19 to determine whether to promote tennis shoes (Alternative 1) or walking shoes (Alternative 2). If an amount is zero, enter "0". Use a minus sign to indicate costs. Ifrequired, use a minus sign to indicate a loss.Differential AnalysisPromote Tennis Shoes (Alt. 1) or Promote Walking Shoes (Alt. 2)June 19PromotePromoteDifferentialTennis ShoesWalking ShoesEffects(Alternative 1) (Alternative 2) (Alternative 2)

Under differential analysis, we would measure the difference in income due to adoption of…

1. Prepare a differential analysis as of June 19 to determine whether to promote tennis shoes (Alternative 1) or walking shoes (Alternative 2). If an amount is zero, enter "0". Use a minus sign to indicate costs. If required, use a minus sign to indicate a loss. Differential Analysis Promote Tennis Shoes (Alt. 1) or Promote Walking Shoes (Alt. 2) June 19 Promote Promote Differential Tennis Shoes Walking Shoes (Alternative 1) (Alternative 2) (Alternative 2) Effects Revenues Costs: Direct materials Direct labor Variable factory overhead Variable selling expenses Sales promotion Profit (loss) 2. Determine whether to promote tennis shoes (Alternative 1) or walking shoes (Alternative 2).

1. Prepare a differential analysis as of June 19 to determine whether to promote tennis shoes (Alternative 1) or walking shoes (Alternative 2). If an amount is zero, enter "0". Use a minus sign to indicate costs. If required, use a minus sign to indicate a loss. Differential Analysis Promote Tennis Shoes (Alt. 1) or Promote Walking Shoes (Alt. 2) June 19 Promote Promote Differential Tennis Shoes Walking Shoes (Alternative 1) (Alternative 2) (Alternative 2) Effects Revenues Costs: Direct materials Direct labor Variable factory overhead Variable selling expenses Sales promotion Profit (loss) 2. Determine whether to promote tennis shoes (Alternative 1) or walking shoes (Alternative 2).

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter3: Merchandising Company Worksheet (p2work)

Section: Chapter Questions

Problem 6R: Open P2WORK4 and click the Chart sheet tab. On the screen, a pie chart shows the percentage...

See similar textbooks

Similar questions

Scattergraph Method Refer to the information for Luisa Crimini above. Required: CONCEPTUAL CONNECTION Prepare a scattergraph based on Luisas data. Use monthly cost for the vertical axis and number of appointments for the horizontal axis. Based on an examination of the scattergraph, does there appear to be a linear relationship between the cost of tanning services and the number of appointments? Use the following information for Exercises 3-44 through 3-46: Luisa Crimini has been operating a beauty shop in a college town for the past 10 years. Recently, Luisa rented space next to her shop and opened a tanning salon. She anticipated that the costs for the tanning service would primarily be fixed, but found that tanning salon costs increased with the number of appointments. Costs for this service over the past 8 months are as follows:
Q.Calculate the cost of a snowboard manufactured in January 2018.
6. Salary of the programmer in the soft ware house. Question 2: It is usually seems as cost accounting cover the financial accounting problems as: • Evaluation of alternative while buying Problem of price assessment Question 3: State whether following statement are true or False, with reason. Financial Accounting provided information for nrice determination
* Question Completion Status: A Moving to another question will save this response. Question 3 Selling expenses DOES NOT include: O A. Delivering goods to customers O B. Accounting and Human Resources expense OC. Advertising expense D. Making sales Moving to another question will save this response.
1.Based on the data above. What is the cost of goods sold on January 1,2020? 2.Based on the data above. What is work in process on January 1, 2020?
Use the following information to answer the questions that follow. A. Calculate the operating income percentage for each of the courses. Comment on how your analysis has changed for each course. B. Perform a vertical analysis for each course. Based on your analysis, what accounts would you want to investigate further? How might management utilize this information? C. Which method of analysis (using a dollar value or percentage) is most relevant and/or useful? Explain
i need the solution for the two blanks in requirement 3. the safety stock ____ pairs & the reorder point _____ pairs of shoes. Check the image for requirement 3 as i alreacy have most blanks filled out
Why is it important to fully understand the cost associated with each item you sell or each service you provide? At the end of the day what does it mean?
Method of Least Squares Refer to the information for Luisa Crimini on the previous page. Required: 1. Using a computer spreadsheet program such as Excel, run a regression on these data. Based on the regression output, write the cost formula for tanning. (Note: Round the fixed cost to the nearest dollar and the variable rate to the nearest cent.) 2. Using the formula computed in Requirement 1, what is the predicted cost of tanning services for September for 2,500 appointments? Use the following information for Exercises 3-44 through 3-46: Luisa Crimini has been operating a beauty shop in a college town for the past 10 years. Recently, Luisa rented space next to her shop and opened a tanning salon. She anticipated that the costs for the tanning service would primarily be fixed, but found that tanning salon costs increased with the number of appointments. Costs for this service over the past 8 months are as follows:
MULTIPLE CHOICE: 1. Costs that are treated as assets until the product is sold are called A. Product cost B. Period cost C. Conversion cost D. None of these 2. Which of the following appears in the balance sheet debit column of a worksheet? A. Service revenue B. Income summary C. Owner withdrawals D. Accounts Payable
toring Enabled: Chapter 4 The Art of Modellin. 6 Help Save & Exit Saved A student prepared the following spreadsheet model to calculate the final price of clothing items which are sold at a discount To be complete, the student included a calculation of sales tax in the final price, given the original price (130), discount (0.21), and sales tax rate (0.06) shown below. A 1. 2 Original Price 3 Discount (%) 4 Discount ($) 5 Net Price 6 Sales Tax(%) 7 Sales Tax($) 130 0.21 = B2 x B3 = B2 B4 0.06 ROUND (B5 X B6, 2) = ROUND (B5 + B7,2) 8 Final Price Determine what values the spreadsheet should display. (Round your answer to 2 decimal places.) Cell Value B4 (Discount in dollars) B5 (Net Price) B7 (Sales tax in dollars) B8 (Final Price) aw
dy) A PS AaBbCc AaBbCc AaBbCc AaBbCc Find AaBbCc No Spacing ab x, x' Aa v Iv A v E E T Normal Heading 1 Heading 2 Heading 3 Repla Font Paragraph Styles Editing Question 4: Scenario company supplies furniture to three local retailers, Danny, Penner, and Victor Inc. The following exhibit presents representative revenues and costs of Scenario by customers for the year 2019. Additional information on Scenario's costs for different activities at various levels of the cost hierarchy is as follows: Danny Penner Victor Total Sales $540,000 $340,000 $450,000 $1,330,000 $970,000 Cost of goods sold 370,000 220,000 380,000 Materials-handling labour 47,000 20,000 37,000 $104,000 Materials-handling equipment (Cost written off as amortization) $24,000 $36,000 $32,000 10,000 6,000 8,000 Rent 14,000 8,000 14,000 Marketing support 12,000 9,000 11,000 Purchase orders and delivery processing 13,000 $32,000 $48,000 $1,246,000 7,000 12,000 Gene adr 20,000 12,000 16,000 Total operating costs 486,000 282,000…