Formula: Divide, Add, Subtract; Cell Referencing

Some cells are merged.

Chapter $11$ AP$11\mathrm{.}2$ a$.$ part $1.$ Using Excel to Perform Analytical Procedures on Revenue Student Work Area

Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work areas as indicated.

PROBLEM

The following data was taken from the production and accounting records for Casuccio Manufacturing, Inc. $($Amounts in thousands$)$

Calculate the following ratios for $2026,2025,$ and $2024$

Unaudited $2026$ Audited $2025$ Audited $2024$

$202620252024$

Operating Data Sales to total assets

Capacity in units $450,000450,000450,000$

Production in units $450,000400,000300,000$ Units sold

Ending inventory in units $32,00028,00021,000$

Sales to production ratio in units

Financial Data $($$$000)$

Total revenues $$35,200$ $$27,500$ $$21,200$ Revenue per unit sold

Total assets $23,00019,50015,700$

Accounts receivable, net $5,9004,3003,900$ Accounts receivable growth

Bad debt expense $175135105$

Accounts receivable written off $165125100$ Sales growth

Ending inventory in units at the end of $202322,000$ Accounts receivable growth to sales growth