Question

In: Accounting

A Candy Company plans to sell 3,000 candy bars with the following information:                  Financial Information        &nbs

A Candy Company plans to sell 3,000 candy bars with the following information:

                 Financial Information                                                                  

         Selling price per candy bar.........................................................................               $1.00

         Variable cost of goods sold per candy bar...............................................               $ .40

         Fixed manufacturing cost per year.............................................................           $12,000

Variable cost of goods sold per candy bar....................................................               $ .30

         Variable selling and administrative expense per candy bar......................               $ .05

         Fixed selling and administrative expense..................................................            $ 4,000

Instructions: Using Excel, prepare the following

  1. CVP formatted income statement
  2. Break even point in units
  3. Break even point in dollars
  4. Margin of safety in dollars
  5. Margin of safety ratio

display all the formulas

Solutions

Expert Solution

If you have any doubts please comment on the answer.


Related Solutions

Moorcroft Company plans to sell 3,000 candy bars with the following information:                  Financial Information        &n
Moorcroft Company plans to sell 3,000 candy bars with the following information:                  Financial Information                                                                             Selling price per candy bar.......................................................................$1.00          Variable cost of goods sold per candy bar.................................................$.40          Fixed manufacturing cost per year............................................................. $12,000 Variable cost of goods sold per candy bar.................................................$.30          Variable selling and administrative expense per candy bar.........................$.05          Fixed selling and administrative expense..................................................$ 4,000 Instructions: Prepare the following CVP formatted income statement Break even point in units Break even point in dollars Margin of...
The following information relates to the Jimmy Johnson Company.                                &nbs
The following information relates to the Jimmy Johnson Company.                                     Ending Inventory                    Ending Inventory Date     At Base-Year Cost At Current Year Cost Price Index ___________________________________________________________________________________________ 12/31/15 (base)                 $68,400                                  $68,400                                    1.00 12/31/16                            $91,600                                 $122,744                                   1.34 12/31/17                            $89,800                                 $132,904                                   1.48 Using dollar-value LIFO, 2016 ending inventory is? Using dollar-value LIFO, 2017 ending inventory is? What is the change in inventory in base-year prices in 2016 (i.e., comparing 2016 ending...
Peninsula Candy Company makes three types of candy bars: Chewy, Chunky, and Choco-Lite (Lite). Sales volume...
Peninsula Candy Company makes three types of candy bars: Chewy, Chunky, and Choco-Lite (Lite). Sales volume for the annual budget is determined by estimating the total market volume for candy bars and then applying the company's prior year market share, adjusted for planned changes due to company programs for the coming year. Volume is apportioned among the three bars based on the prior year's product mix, again adjusted for planned changes for the coming year. The following are the company...
Candy  Company manufactures candy and has the following information for june 2010. Sales totaled $4,125,000.00 and gives...
Candy  Company manufactures candy and has the following information for june 2010. Sales totaled $4,125,000.00 and gives a 4% commission to its sales staff charged as a selling expense. A total of 100,000 direct labor hours were worked for the month with a rate of $6.00 per hour. Raw materials purchases $ 500,000.00 Salaries of Sales Staff 320,000.00 Salary of General Manager 250,000.00 Utilities Expense - Factory 190,000.00 Rent for factory 170,000.00 Administrative Salaries 140,000.00 Rent for Sales Shop 130,000.00 Indirect...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by placing direct materials (raw chocolate, milk, and sugar) into the Blending Department. All materials are placed into production at the beginning of the blending process. After blending, the milk chocolate is then transferred to the Molding Department, where the milk chocolate is formed into candy bars. The following is a partial work in process account of the Blending Department at March 31, 2016: ACCOUNT...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by placing direct materials (raw chocolate, milk, and sugar) into the Blending Department. All materials are placed into production at the beginning of the blending process. After blending, the milk chocolate is then transferred to the Molding Department, where the milk chocolate is formed into candy bars. The following is a partial work in process account of the Blending Department at March 31, 2016: ACCOUNT...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by placing direct materials (raw chocolate, milk, and sugar) into the Blending Department. All materials are placed into production at the beginning of the blending process. After blending, the milk chocolate is then transferred to the Molding Department, where the milk chocolate is formed into candy bars. The following is a partial work in process account of the Blending Department at March 31, 2016: ACCOUNT...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by placing direct materials (raw chocolate, milk, and sugar) into the Blending Department. All materials are placed into production at the beginning of the blending process. After blending, the milk chocolate is then transferred to the Molding Department, where the milk chocolate is formed into candy bars. The following is a partial work in process account of the Blending Department at March 31, 2016: ACCOUNT...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by placing direct materials (raw chocolate, milk, and sugar) into the Blending Department. All materials are placed into production at the beginning of the blending process. After blending, the milk chocolate is then transferred to the Molding Department, where the milk chocolate is formed into candy bars. The following is a partial work in process account of the Blending Department at March 31, 2016: ACCOUNT...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by placing direct materials (raw chocolate, milk, and sugar) into the Blending Department. All materials are placed into production at the beginning of the blending process. After blending, the milk chocolate is then transferred to the Molding Department, where the milk chocolate is formed into candy bars. The following is a partial work in process account of the Blending Department at March 31, 2016: ACCOUNT...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT