Semester Case - Cowboy Ice Cream, Inc. CIC had budgeted its Wholesale Division sales at $8 per unit. CIC planned to sell 4,000 units of ice cream to retail customers during May 2018. But, by lowering the sales price to $7.50 per unit, the company was able to increase the actual number of units sold to 4,500. Required a. Determine the sales volume variance and indicate whether it is favorable (F) or unfavorable (U). Master Budget 4,000 Units Flexible Budget 4,500 Units Volume Variance Sales ($8 per unit) W.T. is considering changing the pricing strategy for the Retail Division, but wonders about the potential effects on the firm's net income if he changes the price per bar that the firm charges its customers. For June, he plans to only operate the truck for the standard 40 operating hours that he also used in May. This means that many of the operating costs are in effect fixed. The following basic data pertain to June 2018: Variable costs (per bar): Manufacturing and storage cost per ice cream bar $1.34 Cost of paper goods per bar 0.03 Expected fixed costs (total for the month): Labor cost $2,700 Depreciation on truck 750 Gas for truck 2,000 General and administrative costs 573 Required (round all computations to the nearest whole dollar): a. Prepare the pro forma income statement that would appears in the master budget if the firm expects to sell 5,000 bars in June at $4.00 per bar. b. A marketing consultant suggests to W.1. that the retail price may affect the number of bars the firm sells. According to the consultant's analysis, if CIC charges customers $3.75 per bar, the firm can sell 5,750 bars. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the firm raises its rate to $4.25 per bar, the number of bars sold will decline to 4,500. Prepare a flexible budget using the new assumption. b. C. Standard Master Budget Flexible Budget Flexible Budget Costs $4/bar $3.75/bar $4.25/bar 5,000 bars 5,750 bars 4,500 bars b. Determine the flexible budget variance, and indicate whether it is favorable (F) or unfavorable (U). Flexible Budget Actual Revenue Flexible Budget 4,500 Units 4,500 Units Variance a. Sales Sales Revenue Variable costs: c. Did lowering the price per unit increase profit? Explain. Mfg and storage $1.34/ea. Paper goods $0.03/ea. Contribution margin Fixed costs: Labor $2,700 Depreciation $750 Gas for truck $2,000 General and Admin. $573 Net income d. Evaluate the three possible outcomes you determined in Requirements a, b, and c and recommend a pricing strategy. Survey of Accounting Packet 18 E15-5 Compute variances for the following items and indicate whether each variance is favorable (F) or unfavorable (U) Item Budget Actual Variance Favorable (F) or Unfavorable (U) Sales price $400 $390 Sales revenue $360,000 $390,000 $192,500 $180,000 Cost of goods sold Material purchases at 5,000 pounds Materials usage $137,500 $140,000 $90,000 $89,000 Production volume 950 units 900 units Wages at 4,000 hours $30,000 $29,350 $48,000 $48,500 Labor usage at $12 per hour Research and development expense Selling and administrative expenses $11,000 $12,500 $24,500 $20,000