Q7. Gears Inc., based in Surrey, British Columbia, offers a comprehensive array of environmentally friendly bicycles. Gears Inc. takes pride in its implementation of clean energy in its manufacturing plant. Gearssells two types of bikes: mountain and road.Each mountain bicycle sells for$859and road bicycle for $325. The per unit variable costs for a mountain bike include $275in raw materials, $10.95in packaging, $12.50in manufacturing overhead, and $9.95in shipping. The variable costs for a road bike are $75in raw materials, $7.95in packaging, $12.13in manufacturing overhead, and $5.05in shipping. Gears fixed costs include office rent of $85,000, office supplies of $25,000and marketing expenses of $48,000. Create a spreadsheet that provides the income position of the company for the upcoming year. The company projects demand to be 500for mountain bikes, and 800for road bikes. Assuming a unit to unit sale, what is a more profitable product for Gears? Determine the break-even for each product, assuming that fixed expenses are allocated as follows: 60% for mountain bikesand 40% for road bikes. Provide a chart showing the break-even point for each product.

Q8.Sally Artisan Bakery makes a variety of organic bread. The bakery is open every day from 7 AM to 6 PM. At 4 PM each day, the bakery marks down its goods by 25%. It also offers a 10% discount every Sunday before 10 AM. Design a spreadsheet that displays the current date/time in one cell. Have your spreadsheet display the correct amount due when the user enters a sale amount, assuming no taxes will be charged.

Q9. RanikaEnergy would like to record its machinery runtime in seconds. Design a spreadsheet model that accepts as inputs the start and end time in hours, minutes, and seconds. Set the model to display the machine time in seconds.

Q10.EDriveInc. is a manufacturing company that specializes in the manufacture of sustainable vehicles? The company began manufacturing its E-line sports coupe at the start of the workday on Tuesday of the current week. The production cycle consists of five processes. A process begins on the next working day after the previous process finishes. For example, Process 2 begins the next working day after Process 1. Assuming that working days are Tuesday to Saturday and there are no holidays, design a spreadsheet that accepts as inputs the duration (in days) of each of the five processes. The spreadsheet should then display the date at which each process starts and completes