Solve each problem below in its own worksheet and identify each sheet with the question number (for example, 91, 92, 93 ...). Order the worksheets sequentially. Bradley Inc. specializes in the manufacture of sustainable equipment. The company wil begin manufacturing its E-line heat pumps at the start of the workday on Friday of the current week. The production cycle consists of three 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. Assume that working days are Tuesday to Saturday and there are no holidays. Design a spreadsheet that accepts as inputs the duration (in days) of the three processes. The spreadsheet should then display the date at which each process starts and completes. In Sotoland, workers take Wednesdays and Thursdays off, and the following holidays: February 6, May 2, July 10. August 15. October 1 and December 25. Design a spreadsheet model in which the user can enter start and end dates, and the worksheet returns the total number of working days? Your model should work for end dates entered up to and including December 31, 2031. The result should be blank if no dates are entered 11 Page would like to record its ma mes. A machine starten Jordan Group would like to record its machine runtime in seconds. Design a spreadsheet model that accepts as inputs the start and end times. A machine startend time is recorded in hours, minutes and seconds. For example, 3.20:15. Set the model to display the machine time in seconds. display ple, 3.20 15 Startendt spreadsheet Using the dataset in the wildlife worksheet, write a formula (in a separate worksheet) using the INDEX and MATCH functions to display (based on a year and an organism which the user of your worksheet chooses) the data for the request. For example, if the user chooses the year, 2007 and the organism, Birds, the formula result should display 1217. Sel data validation restricting the selection of the year and organism to those listed in the dataset. If no year or organism is selected, the result should not display #NA. 5 Do Ra Me Corp's commercial department bills customers for their orders in accordance to their "Net 25 EONM" policy. The payment must be made in full within 25 days following the end of the next month from the statement date. Create a model in which a user can enter a statement date, and the spreadsheet retums the appropriate due date. The formula should not display data if no statement date is entered. 10 Bear Brewery, based in Langley, British Columbia, specializes in craft beer. The brewery produces two ales: Amber and Dubbel. Bear Brewery aligns its ale prices with competitors. The brewery sells its Amber for $14.95 per case and its Dubbel for $15.65 per case. The per case variable costs for Amber include $3.50 in raw materials. $0.75 in packaging. $1.20 in manufacturing overhead and $0.55 in shipping. Dubbel's per case variable costs are $3.85 in raw materials, $0.75 in packaging, $1.95 in manufacturing overhead and $0.75 in shipping. Fixed costs include office lease of $25,000, office supplies of $4,500 and marketing expenses of $6,000. Create a spreadsheet that provides the income position of the brewery for the upcoming vear. The brewery projects demand to be 10.000 cases for Amber, and 8,000 cases for Dubbel. Assuming a unit to unit sale, what is a more profitable beer for Bear Brewery? Determine the break-even for each beer, assuming that fixed expenses are allocated as follows: 45% for Amber and 55% for Dubbel. Provide a chart showing the break-even point for each beer. C-Cell Electric sells fuel cells with current year's sales projected to be $600 million. The company is developing a new product, the Electric T roadster, and within the next few vears, the company anticipates entering the car market with its Electric T. The company expects sales of Electric T to be $ 100 million in the year in which it enters the car sales market. Assuming an annual sales growth of 10% for both products (its fuel cells and Electric T car), create a model that accepts as input the year Electric T enters the market. Have your model compute the annual sales for the company from the current year to 2031. 8. Refer to the salary scale grid below. Design a worksheet model that allows the user to enter an employee's start date with the company. Have your model display the number of years employed in full years only), the scale level and salary. The model results should not provide false years or display #NA No. of Years Employed 0 Scale Level 31 Salary $50,400 $53,400 $55,400 $58,500 $62,000 $64,500 $66,400 $70,600 $77,600 $80,600 20 6 7 8 9 10