For the data in the file named Calcitemdata.xlsx, create calculated fields that summarize the sales of dessert
Question:
For the data in the file named Calcitemdata.xlsx, create calculated fields that summarize the sales of dessert (cakes+puddings) and fruits (apples+grapes).
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 57% (7 reviews)
Answered By
Asim farooq
I have done MS finance and expertise in the field of Accounting, finance, cost accounting, security analysis and portfolio management and management, MS office is at my fingertips, I want my client to take advantage of my practical knowledge. I have been mentoring my client on a freelancer website from last two years, Currently I am working in Telecom company as a financial analyst and before that working as an accountant with Pepsi for one year. I also join a nonprofit organization as a finance assistant to my job duties are making payment to client after tax calculation, I have started my professional career from teaching I was teaching to a master's level student for two years in the evening.
My Expert Service
Financial accounting, Financial management, Cost accounting, Human resource management, Business communication and report writing. Financial accounting : • Journal entries • Financial statements including balance sheet, Profit & Loss account, Cash flow statement • Adjustment entries • Ratio analysis • Accounting concepts • Single entry accounting • Double entry accounting • Bills of exchange • Bank reconciliation statements Cost accounting : • Budgeting • Job order costing • Process costing • Cost of goods sold Financial management : • Capital budgeting • Net Present Value (NPV) • Internal Rate of Return (IRR) • Payback period • Discounted cash flows • Financial analysis • Capital assets pricing model • Simple interest, Compound interest & annuities
4.40+
65+ Reviews
86+ Question Solved
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted:
Students also viewed these Business questions
-
In Chapter 1, you identified the Ws for the data in the file Credit Card Bank. For the categorical variables in the data set, create frequency tables, bar charts, and pie charts using your software....
-
For the data in Problem 5, create a scatter plot to see if there is a relationship between overtime hours and days absent. In Problem 5 Days Employee Hours of Overtime Absent 243 126 86 424 236 128...
-
In the last chapter you created some forms for the Roseys Roses. Now the company would like you to help it create some reports to extract information from the database. Make the following changes...
-
Pritchett Company reported the following year-end data: Cash $ 25,000 8,000 Short-term investments Accounts receivable (current) Inventory 19,500 27,500 Prepaid (current) assets 11,000 Total current...
-
Papa Johns International, Inc., operates and franchises pizza delivery and carryout restaurants in domestic and global markets. In its December 30, 2012, 10-K filing with the SEC, Papa Johns...
-
Fenster Corporation manufactures windows with wood and metal frames. Fenster has three departments: Glass, Wood, and Metal. The Glass Department makes the window glass and sends it to either the Wood...
-
Construct and interpret an R-chart and an x@chart from the sample data shown below. Remember to interpret the R-chart before the x@chart. L13028 Data for Exercise 13.28 Sample Measurements x R 1 2 3...
-
Indicate which of the four perspectives in the balanced scorecard is most likely associated with the objectives that follow. 1. Ethics violations. 2. Credit rating. 3. Customer retention. 4....
-
please help Balloons By Sunset (BBS) is considering the purchase of two new hot air balloons so that it can expand its desert sunset tours. Various information about the proposed investment follows:...
-
Idexo Corporation is a privately held designer and manufacturer of licensed college apparel in Cincinnati, Ohio. In late 2019, after several years of lackluster performance, the firms owner and...
-
For the grocery example, create a PivotChart that summarizes the sales of each product at each store for the years 2005 and 2006.
-
From the chip PivotTable example, create a new PivotTable that summarizes the monthly sales of Chips 1 and 3 in France and the United States.
-
Draw a figure similar to the left-hand panel of Figure 16.2, but with DM vertical. Explain why D would also be vertical.
-
how could a government or world leader have used ERM to respond to one of the financial, operational, or governance aspects of the covid19 pandemic? include references for further reading.
-
Computing and Interpreting Return on investment Selected operating data for two divisions of Outlook Brewing, Ltd., of Australia are given below: Division Queensland New South Wales Sales: $4,000,000...
-
Consider a parcel of land that contains an even ages stand of trees currently of age in A in t=0. you have to decide how much longer to allow this stand to grow given that when you cut the stand, you...
-
What does the company report for the following accounts for the most current fiscal year:Enter your answer in thousands.a . Cash$fill in the blank 1 1 , 1 5 4 , 8 6 7 b . Short - term investments (...
-
Consider the translational mechanical system with a nonlinear spring shown below. The spring is defined by s(t)=ks(t), where x(t) is the spring length and f(t) the spring force. Nonlinear spring 0000...
-
Propose two adjustments that you as a Human Resources manager can make to support the changes related to high-performance work systems, technological changes, and a change in the employment...
-
What are the risks and liability factors in an audit? What are the implications to the auditor? What are the implications to the organization? How can the auditor mitigate these risks and liability...
-
Dana manages real estate and is a cash method taxpayer. She changes to the accrual method in 2018. Danas business income for 2018 is $30,000 computed on the accrual method. Her books show the...
-
On January 30, 2017, Amy sells land to Bob for a stated price of $200,000. The full $200,000 is payable on January 30, 2019. No interest is stated. Amy, a cash-method taxpayer, purchased the land in...
-
Prime Corporation begins operations in late 2017. Prime decides to use the single-pool LIFO method. Year-end inventories under FIFO are as follows: 2017 .....................................$110,000...
-
Product Weight Sales Additional Processing Costs P 300,000 lbs. $ 245,000 $ 200,000 Q 100,000 lbs. 30,000 -0- R 100,000 lbs. 175,000 100,000 If joint costs are allocated based on relative weight of...
-
The projected benefit obligation was $380 million at the beginning of the year. Service cost for the year was $21 million. At the end of the year, pension benefits paid by the trustee were $17...
-
CVP Modeling project The purpose of this project is to give you experience creating a multiproduct profitability analysis that can be used to determine the effects of changing business conditions on...
Study smarter with the SolutionInn App