Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Coconut Cookies worksheet contains revenue details of the company, do the following: At the cell C 3 0 , Calculate the Number of units sold

"Coconut Cookies" worksheet contains revenue details of the company, do the following:
At the cell C30, Calculate the Number of units sold when the Net Income of the company becomes 10000$
Populate the two variable Data Table at the range F5:J9 for the units sold and price per unit given there.
Create Scenarios for the Situation when number of units sold becomes 25000 at the Unit Sale price of 10 SAR, give it name "High Sale Low Price". create another scenario for the situation when the number of units sold remains 12000 at the unit sale price of 20 SAR, give it name "Low Sale High Price". Include Net Income in your scenarios as well.
Create scenario summary for these scenarios and insert in a new worksheet, rename this worksheet as "Likely Sales Scenarios".
"Employment" worksheet contains details of employees of a company that has business in various countries, do the following:
The company decided that all the employees living in Riyadh or Jeddah would be given a 10% dearness allowance, whereas those living in other cities would get a flat 6% allowance. At column "DA", calculate the allowance for all employees.
In the "Standing" column, calculate the Years of service for all employees.
All the Employees who have completed 5 years of service and who are working as Programmer will be given an opportunity for on-site development for abroad clients. Decide eligibility at the "If Eligible" column, write "Yes" for all eligible candidates and "-" for the rest of others.
"Insurance package" column indicates the kind of insurance an employee has chosen, use the table given to decide which company will be providing this.
At I52, Find the total number of employees who are working as Quality Analyst

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Database Factory Active Database For Enterprise Computing

Authors: Schur, Stephen

1st Edition

0471558443, 9780471558446

More Books

Students explore these related Databases questions

Question

The Nature of Language

Answered: 3 weeks ago