Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Requirements are to provide writtenaccounting analysis and/or businessrecommendations for each scenario andquestion. Please demonstrate your workand calculations. Thank you Background 2021YTD Results 2022 YTD Results

Requirements are to provide writtenaccounting analysis and/or businessrecommendations for each scenario andquestion. Please demonstrate your workand calculations. Thank you

image text in transcribed
Background 2021YTD Results 2022 YTD Results Production in ounces 2.900,000 3,009,000 Sales Price per ounce 16 Calla Lily Industries manufactures perfumes for the beauty industry. They have one fa- Factory Rent Expense 90q.000.00 904.000.00 Machine Depreciation 309,000.00 109,000.00 cility located in the United States. As a member of their finance team, you are a trusted Factory Supervisors Salary 540.000.00 600,000.00 Factory Maintenance Staff Salary $4,000.00 60,000.00 business advisor. In addition to providing the accounting for the below transactions, Advertising Expense 240,000 00 300.000.00 Sales Representative Base Salary 216 000.00 274000.00 leadership is relying upon your analysis and business advice. Factory Un lities 564,000.00 702,000.00 Scent SAl Expense 106,800.00 132000.00 Scent B1 Expense 106,800.00 132,000 0D Factory Labor Expense 318 000.00 306,000.00 1. Small Factory Tools and Machine Supplies Expense 106,800.00 132,000.00 Questions/Scenarios li. Template for data consolidation: (Revenue has been provided 1. Calla Lily leadership needs you to build a Financial Measures Scorecard for the for you as an example. following metrics: zell YTDResults 2072 YTD Results XOung FavorableAnfavorable Revenue growth 4030800 454.030.00 0.zi Favorable i. Operating Income growth Operating Income growth Gross margin growth Expense reduction/increase li. Revenue growth 1, Production growth lif. Gross margin growth c. Using your data consolidation template, write a summary of results for iv. Expense reduction each metric. You must support your response. v. Production growth b. Using the following data, please calculate year over year performance for each of the above metrics. Consolidate into an Excel spreadsheet using the provided example as a template. i. Data for calculations: Screens 3-4 of 5 Focus - 1 100% Type here to search O 62"F ~ 40) 11:51 PM 4/26/2022

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

Advanced Accounting

Authors: Debra C. Jeter, Paul K. Chaney

7th edition

1119373204, 9781119373254 , 978-1119373209

More Books

Students also viewed these Accounting questions

Question

Show enthusiasm for the position (but not too much).

Answered: 1 week ago