Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting The Impact On Decision Makers An Alternative To Debits And Credits

Authors: Gary A. Porter, Curtis L. Norton

4th Edition

0324272669, 978-0324272666

More Books

Students also viewed these Accounting questions