Posted on by Judy

Four Business questions

[ad_1]
All files needed for each question are attached1.The Excel file Science and Engineering Jobs shows the number of jobs in thousands in the year 2000 and projections for 2010 from a government study. Use the Excel file to compute the projected increase from the 2000 baseline and also the percentage increase for each occupational category. 2.The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of last year. Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions.3.The Excel file President’s Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed-and-breakfast inn during one month. Room rates are the same for one or two guests; however, additional guests must pay an additional $20 per person per day for meals. Guests staying for seven days or more receive a 10% discount. Modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay. 4. A manager needs to identify some information from the Purchase Orders Excel file but has only the order number. Modify the Excel file to use the VLOOKUP function to find the item description and cost per order for the following order numbers: Aug11008, Sep11023, and Oct11020.
[ad_2]Source link
 
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"

Related posts:

  1. Suppose Summit Knolls Lodge Incurs S140 000 Fixed Costs Month Compute Total Fixed Cost Fix Q17773082
  2. Work through the problems in Excel.
  3. Schmaltx, Ltd., produces a variety of specialty beverages. One of its products is made in a separate facility for which monthly rent, administrative costs, and equipment leasing is $50,000. Eight workers handle production and shipping. Each receives salary and fringe benefits of $2,000 per month. Packaging and distribution costs are $1.5 per case, and ingredients cost $3 per case. The product is sold for $9 a case. Determine the following: 1) Write an expression for the cost function, revenue function and profit function in terms of the number of cases of beverage produced, Q. (Assume there is no demand restriction on sales). 2) Find the break-even point algebraically. 3.) Formulate a spreadsheet model that will give the profit. Use the Excel goal seek command (Data > What-If-Analysis > Goal Seek) to calculate the break-even point in part a. 4.a) Using the above spread sheet model find the profit or loss if Schmaltx produces and sells 10,000 cases. 4.b) Using the above spread sheet model find the profit or loss if Schmaltx produces and sells 30,000 cases. 5.) Write an expression for the profit function in terms of demand (in cases) for the beverage (S) and the number of cases of beverage produced (Q). 5.a) Formulate a spreadsheet model that will find the profit. 5.b) Find the cases of beverage to be produced when S= 20,000 cases using the above spreadsheet model. 5.c) Find the cases of beverage to be produced when S= 10,000 cases using the above spreadsheet model.
  4. Apply: Week 3 Case