The Indian Airlines flight from DEL to BLR Profits Accounting Assignment Help

Assignment Task

Introduction to Spreadsheet.
The worksheet Q1 contains a list of names. Highlight in red each name that appears atleast three times.
a. The worksheet Q2a tells you the following information about students who applied to graduate school at Kelley University: gender, desired major, and whether they were accepted or rejected. If you construct the appropriate PivotTable, you will find fewer women are Accepted than men. Do you think Kelley discriminates against women? 
b. For the data in the worksheet Q2b.xlsx, create calculated fields that summarize the sales of dessert (cakes+puddings) and fruits (apples+grapes). 
Shoeco manufactures three types of shoes. Demand for shoes is unlimited and 40 hours per week of machine time and labor are available. A pair of shoes yields the following profit and uses the number of minutes of machine time and labor given in the table below. Assuming the number of pairs of shoes made each week must be an integer, how can Shoeco maximize weekly profit? Data is attached in Q3.xlsx

• Shoe 1 Shoe 2 Shoe 3
• Profit $40 $25 $30
• Minutes labor used 40 20 30
• Minutes machine time used 45 25 26

The worksheet Q4 contains a list of model, year, and price for each of a series of cars.
a. Set up a formula to extract the model and year of the car. 
b. Set up formulas that enable you to enter the model and year of a car and return its price. 
The file Q 5 contains the ranking each of 20 workers has given (on a 0–10 scale) to four jobs. The file also gives the job to which each worker is assigned. Set up a formula to compute each worker’s ranking for the job to which the worker is assigned. (5 marks).The sheet Match_Large gives the product ID codes and unit sales for 500 products. Use the MATCH function to write a single formula that yields the product ID code of the product with the largest unit sales. Show the value for Error 1The Indian Airlines flight from DEL to BLR has a capacity of 250 people. The airline sold 270 tickets for the flight at a price of INR 4563 per ticket. Tickets are nonrefundable. The variable cost of flying a passenger (mostly food costs and fuel costs) is INR 356 per passenger. If more than 250 people show up for the flight, the flight is overbooked and Indian Airlines must pay overbooking compensation of INR 5000 per person to each overbooked passenger. Develop a worksheet (in Airline sheet) that computes Indian Airlines profit based on the number of customers who show up for the flight. 
Refer to the worksheet Singer and resolve the errors and answer the following questions 
How many songs that are exactly three minutes long and sung by Britney Spears were played later than 2004?

• How many songs are sung by Barry Manilow were played in 2004?
• How many songs were sung by singers whose names contain an e?
• How many songs at least four minutes long and sung by Mandy Moore were played in 2007 or earlier?
• How many songs were sung by singers whose last names begin with M?
• The dataset under Q9 show Maruti Suzuki’s 2021 September Sales data which has been downloaded from a trustable website on internet. Use appropriate lookup functions to check:
• If net sales of Sharda motor is better than net Tata motors. Give suitable reasons to substantiate your answers.
• Bajaj performed better in Jun21 than Jun20. If you are working for Bajaj, which lookup function would you use to check which companies performed better in 2021 than Bajaj in 2020
• You are CR and are responsible for farewell of your seniors who are graduating in May 2022. The dataset under Q11 show the budget for your seniors’ farewell. Develop appropriate scenarios to see what the net amount is you may have to spend(from)/retain(in) your pockets if the fixed budget (i.e. from students club) is Rs 15000.

This Accounting Assignment has been solved by our Accounting Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
    
Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.