Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Project 1: CVP Income Statement (10 points) Upload your file to Moodle by the deadline specified. Do NOT email your filel! Sassy Sauces is a
Project 1: CVP Income Statement (10 points) Upload your file to Moodle by the deadline specified. Do NOT email your filel! Sassy Sauces is a company owned by Carla Fernandez. Carla loves to make various salsas, jellies and other condiments for her friends. They have become so popular with friends and family that they have encouraged her to start her own company to sell these products. Using the skills that you have learned in this class, help Carla prepare her break-even analysis to present to the bank for financing her business. The costs to produce the salsa include the following: $1,250 Monthly depreciation expense on food processing equipment -Jars and labels Commission paid to stores that sell the product Monthly cost of leasing the factory to produce the sauces Direct Labor Direct Materials Marketing, website, telephone and other monthly fixed costs Variable manufacturing costs $.60/ jar GOoo $.75/ jar 7500 $2,500 $2.00 /jar $1.00/jar 20,00G 10 $1,000 $1.65/jar 16500 -Officer's salary $2,000 During the first month of operations, Sassy Sauces plans to manufacture and sell 10,000 jars of salsa. The salsa will sell for $7.50 per jar. Requirements- Using Excel, prepare the following: 1. A traditional (functional) income statement. 2. A CVP income statement. 3. Calculate break-even in units and in sales dollars. 4. Calculate sales (in units and in dollars) needed to target a net income of $15,000 Instructions: 1. Use formulas! Make sure to link the information between statements. Label worksheets. 2. Be sure to label your answers. meant." Don't assume that your instructor will "know what you
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