You have been hired as a consultant for Bravo

You have been hired as a consultant for Bravo Baking Company, who began operations in May of 2010 with the production and sales of specialty breads. The company has experienced a good market demand for its high protein, low carbohydrate product called “Hi-Lo.” Hi-Lo’s success has required that Bravo continue to make only this one product, however, Bravo’s customers, the local retailers, have been asking for more specialty breads from the company.Using the information provided in Table A prepare the Cost of Goods Manufactured Schedule and the Cost of Goods Sold Schedule.Bravo Baking identified the costs in Table B to determine its cost of one unit of product and its monthly operating costs. Using these costs compute the Breakeven units (round to 2 decimal places), Break-even sales dollars, Contribution Margin, Contribution Margin Ratio (%). If Bravo requires a profit of $5,000 how many units must it sell, and how much total Revenue? If Bravo actually sells 8,000 units, what is the margin of safety in Dollars, and percentage?Bravo Baking Co has recently expanded its product line to include several other specialty breads the operating result for the last quarter are provided in Table C. Bravo wants to know the effect on Net income if it decides to discontinue the Fruit & Nuts Product. If Bravo eliminates Fruit & Nuts 50% of fixed cost can be avoided. Prepare an incremental analysis showing the net income effect of eliminating the Fruit & Nuts product. Using table C compute the net income for Bravo Baking after eliminating the Fruit & Nuts product.Requirements:1. Provide a detailed explanation of results from calculations, include schedules and calculations as exhibits.2. What recommendation and advice would you make about Fruit & Nuts?Table ABakers Wages$32,000Rent for executive offices$36,000sales Commissions$10,000Utilities used in the factory$5,000advertising costs$12,000Delivery Truck Costs$25,000Depreciation on bake ovens$500Interest of bank loan$250Beginning Inventory Materials$10,000Beginning Work in Process$8,000Ending Inventory Materials$4,000Inventory Purchases$26,000Ending Work in Process$2,500Other Overhead Costs$1,200Beginning Finished Goods Inventory$7,500Ending Finished Goods Inventory$6,000Rent of Factory$7,500Table BVariableFixedMaterial used in baking bread$2.29Saes Commissions$0.12Bakers Wages$2.29Rent for Executive Offices$3,000.00Factory Supervisor Salaries$3,500.00Utilities used in the Factory$0.50Advertising costs$1,000.00Delivery Truck Depreciation$400.00Depreciation of Bake Ovens$0.07Interest on Bank Loan$500.00Total Costs$5.27$8,400.00Price Charged per unit$7.77Table CProductHi-LoWhole GrainFruit & NutsTotalRevenues$67,575$31,800$15,900$115,275Variable Product Costs$27,030$12,720$6,360$46,110Variable Selling & Administrative Costs$13,515$6,360$3,180$23,055Contibution Margin$27,030$12,720$6,360$46,110Fixed Product Costs$5,000$5,000$5,000$15,000Fixed Selling & Administrative Costs$5,700$2,850$2,850$11,400Allocated Common Costs$5,000$2,500$2,500$10,000Net Income$11,330$2,370-$3,990$9,710