Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

NOVA Knights just completed the 2 0 2 3 fiscal period ( January 1 - December 3 1 ) and through management analysis and review

NOVA Knights just completed the 2023 fiscal period (January 1- December 31) and through management analysis and review of the income statement the following information was determined:
Sales Revenue of $1,578,500 based on sales of 225,500 units.
Cost of Goods Sold totaled $1,014,750.
70% of COGS (Cost of Goods Sold) are variable.
Selling Expenses totaled $410,000.
45% of selling expenses are variable
Administrative Expenses totaled $189,300
40% of administrative expenses are variable
Rounding and Calculation Instructions
Round all costs per unit to 2 decimals
FINAL break-even answers to the unit and dollar (no decimals).
DO NOT Round the contribution margin ratio.
Maintain the same percentages of variable vs. fixed costsPart 1. Using the information above prepare, in good form using Google Sheets(don't forget to share it before submitting), an accrual basis income statement, determine net income (loss) and compute the break-even point in total sales dollars and in units for 2023.
Prepare part 2 using the CVP income statement format and show all computations (embedded formulas within excel or google sheets are required for ALL calculations).
Part 2.
PLAN A - Lorna has proposed a plan to improve its profitability. Lorna feels that the quality of the final product could be substantially improved by spending $0.23 more per unit on higher quality raw materials. The selling price per unit could be increased to $7.35. Lorna projects that sales volume will increase by 22%. Compute net income under Lorna's proposal and the break-even point in units and sales dollars.
(DO NOT Round the contribution margin ratio.).
PLAN B - Anh was a sales and marketing major in college. Anh believes sales volume can be increased by using an intensive online advertising and social media promotional campaign. She proposed the following plan as an alternative to Lorna's: (1) improve sales incentives by increasing sales commission for each sale, this will increase the following variable costs: cost of goods sold to $3.16? per unit, selling expenses to $0.85? per unit, administrative expenses to $0.55? per units, (2) increase the selling price per unit by $0.57, and (3) increase fixed selling expenses by $45,840. Anh based her recommendations on a marketing research report that suggested that sales volume would increase by 21% if these changes were made. Compute net income under Anh's proposal and the break-even point in unit and sales dollars.
(DO NOT Round the contribution margin ratio.).
Part 3.
Which plan do you believe should be
image text in transcribed

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

Step: 3

blur-text-image

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

Cost Accounting A Managerial Emphasis

Authors: Charles T. Horngren, Srikant M.Dater, George Foster, Madhav

13th Edition

8120335643, 136126634, 978-0136126638

More Books

Students also viewed these Accounting questions

Question

=+c) What do you conclude about the average value of the

Answered: 1 week ago