Question
ACTUAL FORECAST 2018 2019 Total Revenue $71,879 Cost of Revenue $(51,125) Gross Profit $20,754 Operating Expenses: Selling, General, and Administrative $(14,248) Research and Development $-
ACTUAL FORECAST 2018 2019 Total Revenue $71,879 Cost of Revenue $(51,125) Gross Profit $20,754 Operating Expenses: Selling, General, and Administrative $(14,248) Research and Development $- Special Income/Other Charges $(2,194) Total Operating Expenses $(16,442) Operating Income $4,312 Net Interest Income $(666) edite Pre-Tax Income $3,646 Provision for Income Tax (19.5%) $(711) Net Income $2,935 The total revenue numbers over the past 4 years for Tag-It Corporation were as follows: Values in Millions: 72,618 73,785 69,495 71,879 Determine whether you think Tag-It can hit the target of a 10% increase in sales next year. Submit the Excel spreadsheet provided, which must include the answers to the 2 questions: 1. An updated forecast for next year, and 2. the answer to question regarding the target sales.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started