Please Solve A-D, Thanks!

The Snazzy Pup Company makes many items and one of them is a special dog collar. The following information pertains to the product: Administrative costs $200,000 REQUIRED: On the basis of the facts as given above, prepare the following schedules using a spreadsheet software package (preferably Excel). Each situation is independent of the others. A. Prepare the income statement using the original data. B. Snazzy Pup is thinking of adding more sales people. This will double the selling costs. Assume they can double the number of items sold with this change. Prepare a new income statement showing these changes. C. Snazzy Pup is wondering what would happen if they only sell half as many items. Assume selling and administrative costs stay the same. Prepare a new income statement showing these changes. D. Snazzy Pup is considering cutting sales prices to $17.00 per collar in hopes of doubling sales. Assume selling and administrative costs stay the same. Prepare a new income statement showing these changes