Question: Below are instructions for each: Utilizing the financial information below for The Cookie Company, complete a budget performance report combining activity variances and revenue and
Below are instructions for each:
Utilizing the financial information below for The Cookie Company, complete a budget performance report combining activity variances and revenue and spending variances like that in Exhibit on page of the textbook. Please be sure to include Favorable vs Unfavorable indicators for each variance. The report must be created from scratch in Excel. Each student's report should be completely unique even if following similar formats. Formulas MUST be used for ALL calculations, and the final submission must be made in Excel to grade calculations properly.
The Cookie Company
Income Statement
For the Year Ended December
tableBudget Information,Actual ResultsQuantity Sold,Sales$q$ Cost of Goods SoldFlour$q$ Sugar$qOil$qChocolate$qEggs$qPackagingSupplies$qGross Margin,,$ Utilities$ Insurance$ Office Supplies,$ SalariesWages$ $qCommissions$qJanitorial Expense,$ Rent$ Repairs$ Depreciation$ Marketing$ SoftwareIT$ Human Resources,$ Accounting Fees,$ Other Management Expenses,$ Legal Fees,$ Total Selling & Administrative Expenses,,Net Operating IncomeLoss$
PLEASE SHOW IN EXCEL, WITH FORMULAS AND CELL REFERNCES
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
