Answered step by step
Verified Expert Solution
Link Copied!

Question

00
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 with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Databases questions

Question

What are the attributes of a technical decision?

Answered: 1 week ago

Question

How do the two components of this theory work together?

Answered: 1 week ago