Essay Available:
Pages:
1 page/β275 words
Sources:
No Sources
Style:
APA
Subject:
Accounting, Finance, SPSS
Type:
Other (Not Listed)
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 4.68
Topic:
Sustainable purchasing and cost controll
Other (Not Listed) Instructions:
there are 2 different problems both need to be solved in EXCEL. they can be solved on same excel sheet
problem 1: capture 1 is for problem 1
Copy the above information into a Microsoft Excel file and prepare both weekly and monthly (four weeks) profit figures so that Jim has a good idea about the current profit situation. Also, given the sales for the month, explain how much Jim's ideal expenses should have been to realize his desired profit of $1,700.
Be sure to show the formulas you used for each calculation. You could embed the formulas into your MS Excel spreadsheet, which lets me see the formulas and also allows the computer to calculate the results for you so you would not need to use a calculator.
problem 2: capture 2 is for problem 2
Mary is the bookkeeper at Happiness Grill. In the table below, you can see the company's paper good costs. Use the information to calculate the percentages for each month. Make sure to show the formulas you used and the calculations you performed.
Other (Not Listed) Sample Content Preview:
Accounting
Name
Institution
Accounting
Problem 1
Profit and loss account of any business shows the financial performance of an organization. In this case, Jim diner operation was fairing on well although the operation experienced a number of profit fluctuation all the way from week one to week four. For instance, the firm started at a profit of $132.7 in week one then profits shot very highly in week two to $725.14 before dropping gradually $471.66 and $158.91 respectively in week three and four.
The calculations were obtained as indicated below.
Problem 1Revenues and losses for Jim DinerWeekRevenue ($)Expenses ($)Profit/Loss ($)1994.5861.8132.721,447.60722.46725.1431,361.80890.14471.6641,645.111,486.20158.91Totals5449.013960.61488.41Profit/loss for Jim's diner is obtained by the Formula Revenue - Expenses
The profit fluctuation from week one to week four might have been due to the following aspects:
The business was still new in week one
In week two, clients had heard of the new services being provided and they all wanted to have a firsthand experience. But in week three and four, the services offered might not have impressed the clients as they expected; thus leading to the profit decline.
From the computation, Jim managed a profit of $1488.41 which was less than his target of $17...
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:
π Other Visitors are Viewing These APA Other (Not Listed) Samples:
- Annual Report Project3 pages/β825 words | 1 Source | APA | Accounting, Finance, SPSS | Other (Not Listed) |
- Response to Client Request I: Direct financing, sales type, and operating leases3 pages/β825 words | 2 Sources | APA | Accounting, Finance, SPSS | Other (Not Listed) |
- Leasing Of Three New Trucks 1 page/β275 words | 2 Sources | APA | Accounting, Finance, SPSS | Other (Not Listed) |
- Required Reporting for Defined Contribution, Defined Benefit, and other Postretirement Plans3 pages/β825 words | 3 Sources | APA | Accounting, Finance, SPSS | Other (Not Listed) |
- The Operating segments within Microsoft1 page/β275 words | 2 Sources | APA | Accounting, Finance, SPSS | Other (Not Listed) |
- Auditing a Publicly Traded Company3 pages/β825 words | 3 Sources | APA | Accounting, Finance, SPSS | Other (Not Listed) |
- Auditing and Assurance Services Provided by Ches Hudson & Associates3 pages/β825 words | 2 Sources | APA | Accounting, Finance, SPSS | Other (Not Listed) |