Business, 03.04.2021 03:30 gvizabal

Ensure the Sales worksheet is active. Enter a function in cell B8 to create a custom transaction number. The transaction number should be comprised of the item number listed in cell C8 combined with the quantity in cell D8 and the first initial of the payment type in cell E8. Use Auto Fill to copy the function down, completing the data in column B. Enter a nested function in cell G8 that displays the word Flag if the Payment Type is Credit and the Amount is greater than or equal to $4000. Otherwise, the function will display a blank cell. Use Auto Fill to copy the function down, completing the data in column G.
Create a data validation list in cell D5 that displays Quantity, Payment Type, and Amount.
Type the Trans# 30038C in cell B5, and select Quantity from the validation list in cell D5.
Enter a nested lookup function in cell F5 that evaluates the Trans # in cell B5 as well as the Category in cell D5, and returns the results based on the data in the range A8:F32.
Create a PivotTable based on the range A7:G32. Place the PivotTable in cell I17 on the current worksheet. Place Payment Type in the Rows box and Amount in the Values box. Format the Amount with Accounting Number Format.
Insert a PivotChart using the Pie chart type based on the data. Place the upper-left corner of the chart inside cell I22. Format the Legend of the chart to appear at the bottom of the chart area. Format the Data Labels to appear on the Outside end of the chart.
Note, Mac users, select the range I18:J20, on the Insert tab, click Recommended Charts, and then click Pie. Format the legend, and apply the data labels as specified.
Insert a Slicer based on Date. Place the upper-left corner of the Slicer inside cell L8.
Ensure the Inventory worksheet is active. Import the Access database eApp_Cap2_Inventory. accdb into the worksheet starting in cell A3.
Note, Mac users, download and import the delimited Inventory. txt file into the worksheet starting in cell A3.
Sales Sheet
Beta Manufacturing
March Transactions
Trans # Category Results
Date Trans # Item Quantity Payment
Type Amount Status
3/1/2018 3003 8 Credit $4,800
3/2/2018 5005 4 Financed $2,800
3/3/2018 5005 1 Credit $700
3/3/2018 5005 10 Financed $7,000
3/5/2018 1001 6 Credit $1,500
3/7/2018 5005 5 Credit $3,500
3/9/2018 1001 5 Credit $1,250
3/10/2018 5005 3 Credit $2,100
3/10/2018 2002 1 Financed $500
3/10/2018 4004 4 Financed $2,600
3/11/2018 2002 9 Financed $4,500
3/11/2018 3003 8 Credit $4,800
3/12/2018 1001 9 Financed $2,250
3/13/2018 2002 8 Financed $4,000
3/13/2018 2002 9 Credit $4,500
3/14/2018 3003 9 Credit $5,400
3/18/2018 3003 1 Credit $600
3/24/2018 4004 1 Credit $650
3/24/2018 4004 3 Financed $1,950
3/24/2018 4004 10 Cash $6,500
3/28/2018 2002 10 Credit $5,000
3/28/2018 1001 9 Cash $2,250
3/30/2018 3003 8 Credit $4,800
3/30/2018 4004 6 Financed $3,900
3/30/2018 2002 9 Cash $4,500

Answers: 3

Show answers

Another question on Business

Business, 21.06.2019 23:20

On october 2, 2016 starbucks corporation reported, on its form 10-k, the following (in millions): total assets $14,329.5 total stockholders' equity 5,890.7 total current liabilities 4,546.9 what did starbucks report as total liabilities on october 2, 2016? select one: a. $12,516.7 million b. $6,377.3 million c. $995.0 million d. $8,438.8 million e. none of the above

Answers: 2

Answer

Business, 22.06.2019 07:50

In december of 2004, the company you own entered into a 20-year contract with a grain supplier for daily deliveries of grain to its hot dog bun manufacturing facility. the contract called for "10,000 pounds of grain" to be delivered to the facility at the price of $100,000 per day. until february 2017, the supplier provided processed grain which could easily be used in your manufacturing process. however, no longer wanting to absorb the cost of having the grain processed, the supplier began delivering whole grain. the supplier is arguing that the contract does not specify the type of grain that would be supplied and that it has not breached the contract. your company is arguing that the supplier has an onsite processing plant and processed grain was implicit to the terms of the contract. over the remaining term of the contract, reshipping and having the grain processed would cost your company approximately $10,000,000, opposed to a cost of around $1,000,000 to the supplier. after speaking with in-house counsel, it was estimated that litigation would cost the company several million dollars and last for years. weighing the costs of litigation, along with possible ambiguity in the contract, what are three options you could take to resolve the dispute? which would be the best option for your business and why?

Answers: 2

Answer

Business, 22.06.2019 10:50

Bill dukes has $100,000 invested in a 2-stock portfolio. $62,500 is invested in stock x and the remainder is invested in stock y. x's beta is 1.50 and y's beta is 0.70. what is the portfolio's beta? do not round your intermediate calculations. round the final answer to 2 decimal places.

Answers: 2

Answer

Business, 22.06.2019 19:20

Garrett is an executive vice president at samm hardware. he researches a proposal by a larger company, maximum hardware, to combine the two companies. by analyzing past performance, conducting focus groups, and interviewing maximum employees, garrett concludes that maximum has poor profit margins, sells shoddy merchandise, and treats customers poorly. what actions should garrett and samm hardware take? a. turn down the acquisition offer and prepare to resist a hostile takeover. b. attempt a friendly merger and use managerial hubris to improve results at maximum. c. welcome the acquisition and use knowledge transfer to impart sam hardware's management practices. d. do nothing; the two companies cannot combine without samm hardware's explicit consent.

Answers: 1

Answer

You know the right answer?

Ensure the Sales worksheet is active. Enter a function in cell B8 to create a custom transaction num...

Questions