Prepare a budgeted income statement through operating income by quarter and for the year using the contribution margin format--use the format provided on the template as a reference. Then add interest expense to your income statement to determine income before tax. Interest expense can be calculated from the information provided for the cash budget. (For purposes of this project, we will ignore income taxes.)
Using your budgeted income statement for the year, answer the following questions at the bottom of your income statement sheet. You should use operating income in your calculations, not income before tax. Label your answers, but make sure that your answers contain formulas incorporating cell references.
What is the budgeted break-even point in units? (Round to the nearest whole unit)
What is the margin of safety percentage at the budgeted activity level for the year? (Round to the nearest one percent)
What is operating leverage at the budgeted activity level for the year? (Round to one decimal place)
If Crossley wants to earn a $5,500,000 operating profit next year, how many units must the company sell? (Round to the nearest whole unit)
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!