Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CIS 2200 - INTRODUCTION TO INFORMATION SYSTEMS AND TECHNOLOGIES Excel Group Project Introduction NYP, New York Paper Co., is using its financial results for
CIS 2200 - INTRODUCTION TO INFORMATION SYSTEMS AND TECHNOLOGIES Excel Group Project Introduction "NYP," New York Paper Co., is using its financial results for August 2019 (Table 1) as a base for projecting the company's budget for the remaining four months of the year (September-December). Table 1: Financial results for August 2019 (000). REVENUE Wedding Invitations Birthday Party Invitations Business Party Invitations Total Sales Revenue EXPENSES Printing Costs Salaries Administration Advertising Legal Fees Shipping Total Expenses Net Income before Taxes August 4,507 3,841 2,652 11,000 4,400 3,500 550 1,544 788 928 11,710 -710 Taxes Net Profit (loss) 0 -710 Enter the figures for August of 2019 in your worksheet "BUDGET" in the workbook "GROUP ## EXCEL GROUP PROJECT FALL 22". Make sure that you use formulas where appropriate for this base month. All figures should be expressed in thousands of dollars (000), amounts should be formatted with commas and no decimals.
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