Question

Calculate the following ratios for 2023, 2022, 2021

The following data was taken from the production and accounting records for Casuccio Manufacturing, Inc. Unaudited 2023 Audited 2022 Audited 2021 Operating Data Capacity in units 450,000 450,000 450,000 400,000 450,000 300,000 Production in units Inventory in units 32,000 28,000 21,000 Financial Data ($000). Total revenues $35,200 $23,000 $27,500 $19,500 $21,200 $15,700 Total assets Accounts receivable, net $5,900 $4,300 $3,900 Bad debt expense $175 $135 $105 Accounts receivable written off $165 $125 $100

a. Sales to Production

b. Revenue per unit sold

Answer 1

1 Year 2 Capacity 3 Production in units 4 Inventory 5 6 Sales - Production - Increase in inventory 7 Sales/production B 2023 450,000 450,000 32,000 C 2022 450,000 400,000 28,000 D 2021 450,000 300,000 21,000 446,000 0.99 393,000 0.98 279,000 0.93 9 Revenue 10 Revenue per unit 35200000 27500000 21200000 78.92 69.97 75.99

The formula implementation is as shown below:

B 1 Year 2 Capacity 3 Production in units 4 Inventory 2023 450,000 450,000 32,000 2022 450,000 400,000 28,000 2021 450,000 300,000 21,000 6 Sales '= Production - Increase in inventory =B3-(B4-C4) =C3-C4-D4) =D3-D4 7 Sales/production =B6/B3 =C6/C3 =D6/D3 Revenue 10 Revenue per unit 35200000 27500000 21200000 =B9/B6 =C9/C6 =D9/D6