Benicio wants to compare the sales of each product in 2021 with the sales in 2020. He has the 2020 sales data stored in a separate workbook. Add the 2020 sales data to the All Locations worksheet as follows: a. Open the workbook Support_EX19_CS5-8a_2020.xlsx.
b. Return to the All Locations worksheet in the original workbook.
c. In cell Gs, enter a formula using an external reference to display the total sales of Mini products in 2020 (cell F5).
d. In the formula in cell G5, change the absolute reference to a mixed reference, with a relative reference to the row number.
e. Fill the range G6:G8 with the formula in cell G5, filling without formatting.
f. Close the workbook Support_EX19_CS5-8a_2020.xlsx.

25. kerry company plans to sell 200,000 units of finished product in july and anticipates a growth rate in sales of 5% per month. the desired monthly ending inventory in units of finished product is 80% of the next month's estimated sales. there are 150,000 finished units in inventory on june 30. kerry company's production requirement in units of finished product for the three-month period ending september 30 is: a. 712,025 units b. 630,500 units c. 664,000 units d. 665,720 units

Last year, western corporation had sales of $5 million, cost of goods sold of $3 million, operating expenses of $175,000 and depreciation of $125,000. the firm received $40,000 in dividend income and paid $200,000 in interest on loans. also, western sold stock during the year, receiving a $40,000 gain on stock owned 6 years, but losing $60,000 on stock owned 4 years. what is the firm's tax liability?

Vulcan flyovers offers scenic overflights of mount st. helens, the volcano in washington state that explosively erupted in 1982. data concerning the company’s operations in july appear below: vulcan flyovers operating data for the month ended july 31 actual results flexible budget planning budget flights (q) 56 56 54 revenue ($350.00q) $ 16,500 $ 19,600 $ 18,900 expenses: wages and salaries ($3,300 + $91.00q) 8,354 8,396 8,214 fuel ($31.00q) 1,904 1,736 1,674 airport fees ($870 + $35.00q) 2,730 2,830 2,760 aircraft depreciation ($11.00q) 616 616 594 office expenses ($240 + $1.00q) 464 296 294 total expense 14,068 13,874 13,536 net operating income $ 2,432 $ 5,726 $ 5,364 the company measures its activity in terms of flights. customers can buy individual tickets for overflights or hire an entire plane for an overflight at a discount. required: 1. prepare a flexible budget performance report for july that includes revenue and spending variances and activity variances.