(see attached for data on Lewis Company)
Prepare a contribution margin (behavioral, variable) income statement for Lewis Company. Prepare a second version assuming the selling price per unit increases to $320 per unit.
Use the original information to:
? Determine the number of units the company must sell to break even for the year?
? Compute break even assuming direct materials cost increase from $120 to $140, but all information remains the same.
Modular SLP Expectations
It is important to answer the questions as posed. The document should be two to four pages and written in a clear and concise manner or present tables as required. Support your discussion or tables with references in APA format. You are encouraged to use Excel or other compatible spreadsheet when computations are involved. You can turn in the spreadsheet instead. The content should be equivalent to the page length suggested for a word processing document.© BrainMass Inc. brainmass.com September 20, 2018, 1:57 pm ad1c9bdddf - https://brainmass.com/business/income-statement/behavioral-variable-income-statement-for-lewis-company-481951
Your tutorial is in Excel (attached). Please click in cells to see computations. A draft report (334 words including computations as exhibits) as a sample is available for your inspection and as a starting point for your final work.