70.2K

Verified Solution

Link Copied!

The following is Peloton's income statement for the year ended December 31, 2022. \begin{tabular}{|c|c|} \hline SalesRevenue(200,000units) & $2,850,000 \\ \hline ManufacturingCosts & \\ \hline Materials & $168,000 \\ \hline Variablecashcosts & $142,400 \\ \hline Fixedcashcosts & $327,600 \\ \hline Depreciation(fixed) & $999,000 \\ \hline MarketingandAdministrativeCosts & \\ \hline Marketing(variable,cash) & $422,400 \\ \hline Marketingdepreciation & $149,600 \\ \hline Administrative(fixed,cash) & $509,200 \\ \hline Administrativedepreciation & $74,800 \\ \hline Total Costs & $2,793,000 \\ \hline Operating Profits & $57,000 \\ \hline \end{tabular} All depreciation charges are fixed and are expected to remain the same for 2023 . Sales volume is expected to fall by 5%, but prices are expected to rise by 15%. Material costs per unit are expected to increase by 12%. Other unit variable manufacturing costs are expected to decrease by 10% per unit. Fixed costs are expected to increase by 4%. Variable marketing costs will change with unit volume. Administrative cash costs are expected to increase by 5%. Inventories are kept at zero. Peloton operates on a cash basis. Required: Using Excel, prepare a budgeted income statement for 2023. Include the 2022 income statement for comparison purposes

Answer & Explanation Solved by verified expert

See Answer