All of your work should be contained in ONE Excel spreadsheet (though you are welcome to use a separate tab for each question). Put all of your details in the Excel file. You should be using the formulas in Excel, too. It’s extremely important for you to learn to use the many features of Excel. Thus I cannot consider anything submitted in a Word document.
Basic Business Math
1A. A new yarn shop wants to apportion their investment money ($150,000) for advertising, building upgrades, and education in the ratio of 7:8:10. How much money does each category get apportioned?
1B. CatCo has a new line of kitten starter kits. The basic kit features a sandbox,
sand, scooper, three cans of kitten food and catnip. The exotic kit features the premium self-cleaning sandbox with all natural sand, 10 cases of kitten food, a living catnip plant, and a scratching post tower. The basic kit costs $80 and the exotic kit costs $200. Kitten lovers bought 10 times as many basic kits than exotic kits last month. And last month, both types of starter kit had total sales of $16,000 (this is the total for both items). How many basic kits did CatCo sell? How many exotic kits did CatCo sell?
Use Excel’s built-in functions to build the calculator so that Excel will automatically calculate your grade as you enter your grades during the class. You do not need to enter any grades; just enter the functions.
Use a new worksheet called “Grade Calculator” in the same Excel file that you are submitting for this assignment.
After this week you will receive the solution from your professor and you will be able to use our solution for this class.
Hint: Please enter sample scores to test your grade calculator. (If it has no functionality – and is merely a list of assignments – it is not a calculator, and you have a lot more work to do.) I’ll be checking the “interim” grade feature as well.
You should remove your sample scores prior to submitting your homework, but note that your professor will enter sample scores to test your work. Also, your grades in this course will be expressed as percentages (0% to 100%) rather than as points.
bottle-filling machine to package their product is the weight of the food product in the individual bottles. If the bottles are under filled, two problems arise. First,
customers may not have enough product for their needs. Second, the company
may be in violation of the truth-in-labeling laws. In this example, the label weight on the package indicates that, on average, there are 2.5 ounces of product in a bottle. If the average amount of product in a bottle exceeds the label weight, the company is giving away product. Getting an exact amount of product in a bottle is problematic because of variation in the temperature and humidity inside the factory, differences in the density of the product, and the extremely fast filling operation of the machine (approximately 450 bottles per minute). The following table provides the weight in ounces of a sample of 60
bottles produced in one hour by a single machine:
3.00 | 3.06 | 2.45 | 2.06 | 2.09 | 2.51 | 2.78 | 3.08 | 3.08 | 3.04 |
2.16 | 2.47 | 2.96 | 2.41 | 2.42 | 2.29 | 2.71 | 3.09 | 1.98 | 3.05 |
2.97 | 2.20 | 1.88 | 2.80 | 2.52 | 2.41 | 1.98 | 2.39 | 2.59 | 2.52 |
3.01 | 1.98 | 1.79 | 1.99 | 1.38 | 3.06 | 2.73 | 3.04 | 3.22 | 2.52 |
3.07 | 3.03 | 1.89 | 2.39 | 1.41 | 2.22 | 2.14 | 2.89 | 1.81 | 3.04 |
3.06 | 3.11 | 1.59 | 1.91 | 3.02 | 2.99 | 3.01 | 1.89 | 3.01 | 2.33 |
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more