Tag: range

Categories
Writers Solution

Merge & Center the title   across the range A1:F1, and then apply the Title cell style

Excel_1E_Gym_Sales

Project Description:

In the following project, you will create a worksheet comparing the sales of different types of home gym equipment sold in the second quarter.

Open the file Student_Excel_1E_Gym_Sales.xlsx   downloaded with this project.

Change the workbook theme to   Wisp. If the Wisp theme is not available on your computer, in the Themes   gallery, click Browse for Themes, and then select the theme from your   downloaded student data files.

In cell B3, use the fill handle   to fill the months May and June in the range C3:D3.

Merge & Center the title   across the range A1:F1, and then apply the Title cell style. Merge &   Center the subtitle across the range A2:F2, and then apply the Heading 1 cell   style. Center the column titles in the range B3:F3.

Widen column A to 180 pixels,   and then widen columns B:F to 115 pixels. In the range B7:D7, enter the   monthly sales figures for the Elite Home Gym for April, May, and June as   follows:
 

137727.85 for April and 121691.64 for May and 128964.64 for June.
 

  Mac users: Widen column A to 21.83 (136 pixels) and columns B:F to 13.83 (88   pixels).
 

  Note: If any columns are too narrow to display all the data, apply AutoFit to   the column.

In cell B8, on the Home tab, use   the AutoSum button to sum the April sales. Copy the resulting formula across   to cells C8:D8 to sum the May monthly sales and the June monthly sales. In   cell E4, use the AutoSum button to sum the Basic Home Gym sales. Copy the   formula down to cells E5:E8.

Apply the Heading 4 cell style   to the row titles and column titles. Apply the Total cell style to the totals   in the range B8:E8. 

Apply the Accounting Number   Format to the first row of sales figures and to the total row. Apply the   Comma Style to the remaining sales figures.

To compare the monthly sales of   each product visually, select the range that represents the sales figures for   the three months, including the month names and the product names—do not   include any totals in the range. With this data selected, use the Recommended   Charts command to insert a Clustered Column chart with the month names   displayed on the category axis and the product names displayed in the legend.

Move the chart so that its upper   left corner is positioned in the center of cell A10. Then drag the center   right sizing handle to the right until the right edge of the chart aligns   with the right edge of column E; this will display the legend on one row and,   after you add the sparklines, center the chart below the data.

Apply Chart Style 6 and change   the colors by applying the second row of colors under Colorful. Change the   Chart Title to Second Quarter Home Gym Sales

In the range F4:F7, insert Line   sparklines that compare the monthly data. Do not include the totals. Show the   sparkline Markers. Display the sparkline Style gallery, and then in the first   row, apply the second style.

Center the worksheet   Horizontally on the page, and then insert a Footer with the File Name in the   left section.

Change the Orientation to Landscape. Display the document properties,   and then as the Tags, type home gym, sales
 

  As the Subject, type your course name and section number. Be sure your name   displays as the Author. Check your worksheet by previewing it in Print   Preview and then make any necessary corrections.

Save and close the workbook, and   then submit for grading

Categories
Writers Solution

Banksia Chartered Accountants is a successful mid-tier accounting firm with a large range of clients across Australia

Question: Banksia Chartered Accountants is a successful mid-tier accounting firm with a large range of clients across Australia. During the 2022 year, Banksia gained a new client, Sydney Dental (SD),

Question:

Banksia Chartered Accountants is a successful mid-tier accounting firm with a large range of clients across Australia. During the 2022 year, Banksia gained a new client, Sydney Dental (SD), which owns 100 per cent of the following entities:

All Smiles Dapto Limited, a private dental clinic that specialises in the orthodontic treatment.

Wollongong Private Dental Hospital

Nowra Dental Pty Ltd, a dental clinic

Year-end for all SD entities is 30 June.

You are the audit partner reviewing the audit work papers for SD for the year ended 30 June 2022. Today is 13 July 2022 and the audit report is due to be signed in three weeks’ time.

During your review you note that the fixed-term borrowings of SD totalling $150 million are approaching maturity and SD does not seem to have renegotiated any terms of refinancing. You are aware, from your experience with other clients, that banks are reluctant to extend financing on the same terms in the current market. The financing of SD was historically managed by the group’s treasurer who left the group six months ago and has not been replaced.

SD’s financial controller, who has been with the group for nine months, has advised you that she has been busy renegotiating with some of SD’s key suppliers who recently requested cash on delivery for all orders rather than extending the normal credit terms.

You are also aware that a fire that occurred in the hospital cafeteria last week was not adequately covered by insurance. Fortunately, no one was seriously injured in the fire, but the cafeteria was so badly damaged it had to be closed.

While discussing this matter with SD’s law firm, they reveal that the hospital is unlikely to have adequate professional indemnity insurance to meet the current demands of several malpractice cases that have been brought against the hospital in the last 12 months.

REQUIRED

(a) Explain your responsibilities with respect to the cafeteria fire.                         

(b) How should this fire event be handled in the financial report and the audit report?                                                                                    

(c) Suggest three possible going concern issues for SD? Explain. If so, suggest two mitigating circumstances?                                                                                        

(d) How will you recommend any going concern issue be handled in the financial report and the audit report?

WE HAVE DONE THIS ASSIGNMENT BEFORE, WE CAN ALSO DO IT FOR YOU

GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

CLICK HERE TO MAKE YOUR ORDER on Banksia Chartered Accountants is a successful mid-tier accounting firm with a large range of clients across Australia

Are You looking for Assignment and Homework Writing help? We Provide High-Quality Academic Papers at Affordable Rates. No Plagiarism.

TO BE RE-WRITTEN FROM THE SCRATCH

Categories
Writers Solution

Restaurant’s long-range marketing plan, your company purchased property nationwide from the now-bankrupted “Sahara Desert Dish” franchise properties

The Scenario

As a part of the Restaurant’s long-range marketing plan, your company purchased property nationwide from the now-bankrupted “Sahara Desert Dish” franchise properties. Based on your Discussion and Strategic Plan results, your company agreed that it was time to launch its nationwide strategy rolling out  the company’s patented dessert brand, “Brain Freeze.”  Your company’s financial information indicates the company now has a healthy portfolio of investments, product revenue, and cash on hand.

The Restaurant’s dessert menu has produced an exceptional revenue stream.  These products can easily be marketed as a standalone venture. The company portfolio includes the Sahara Desert Dish property purchased in anticipation of this day. The properties are all in upscale locations that easily support the Restaurant’s thematic Desert menu.

 “Sally, ‘It’s now or, never’ you state, we need to start the implementation of our Franchise Division.”  Sally was taken aback by your use of her previous statement. Seeming a little concerned about the plan interfering with her entering the competition for the third Gold Star, you reassure her. “If Wolfgang Puck can open up gourmet pizza shops, that’s the only incentive we need to startup our Desert franchise operation.” Sally fires back, “You’re the one studying business law! Why did it take you so long to bring it up?” Sally continues, “Start working on the documents, and I’ll get started on creating the franchise operations menu and food handling processes.”

In your Discussion, you covered all of the eventualities companies face in expansion periods. Your companies initial investment in the purchase of bankrupt properties has placed the company in a growth position. The commercial paper securing the properties is almost paid off. Converting the properties into a new enterprise will reduce the carrying cost and increase the current revenue streams by a minimum of 20%. Franchise Licensing Fees and property leasing rentals will initially bump revenue by approximately 35%.

To start your review, first, research the requirements required to establish a legally recognized Franchise operation.  Using the Strategic Business Plan and the other resources you now have, complete the Franchise feasibility information and determine what steps are needed to enter this highly competitive area. Review the resources and respond to the Assignment.

Your Assignment

Assignment: Feasibility of Franchise Expansion:

This is a Blue Font exercise: Complete the document using a readable Blue Font.

In Assignment 9.3, you will collect data from your past assignments to develop your outline of franchise business information that you will need to complete the final project in Assignment 9.4. To fully understand the nature of a Franchise operation, review the SBA information, Forms 505, 506, and then complete the Questions in the Basic Franchise Document and the Chart in the Test for Feasibility Documents below.

Review Form 505 Drafting Guide, follow the research outlining the required steps and issues you would potentially encounter developing the required document between the Franchisor and Franchisee, the Franchise Agreement. Document 505 establishes various litigation, state, and federal statutory requirements. Review each category listed using the link and review material. You must review this material to comprehend the statutory and legal guidance required to edit and complete the Franchise Agreement in Assignment 9.4.

Review Form 506 list of issues and limits available for consideration in completing the Checklist questions/answers to revise and draft the agreement.  The questions in 506 are stated, for example, as the question below.

  • — Nature and extent of the rights granted to the Franchisees.
  • — Duration of franchise period.
  • — Exclusiveness of franchise.
  • — Authorized use of a trademark.

This question seeks the limits on three grants to the Franchisee, (1) Duration, (2) Exclusiveness, and (3) Authority. The question asks the Nature (Type) and the Extent (Range or scope) of the rights granted to your Franchisees. The Duration issue asks “what period” (how long) will Franchisee be granted to exercise authority over rights in the agreement, such as the number of years the Franchise will last, are the rights exclusive or non-exclusive (This could be a state or local geographic designation (i.e., State of Ohio, or two city block in the southwest of downtown), use of IP and extent of the right(s) granted.

This Assignment does not call for simply checking boxes on the form. The questions require research and business decisions for your company to establish franchise rights and limitations offered to Franchisees during their operation and ownership of a Franchise. Do not approach this assignment as a lawyer but as the owner of a Franchise. Determine your companies business interest, the profit you wish to achieve, and the rights you want to protect in your Franchise business. Your company’s business strategy will determine the right you grant to Franchisees. Franchises become an extension of your Franchise organization and must meet your company goals.

In the next step, answer the questions listed in the BASIC FRANCHISE AGREEMENT TERMS – CHECKLIST. Franchise agreements vary from state to state and sometimes franchise to franchise, so it’s impossible to identify every term and issue for consistency in all situations. Some terms require negotiating between the parties. Redraft the Franchise Agreement using the information you collected in Assignment 9.3 and the 9.4 Checklist. The Franchise Agreement lists the terms and conditions governing your franchise’s ownership and the Franchisee’s rights. This Assignment does not call for simply checking boxes. Provide thoughtful responses to the issues outlining how to operate the Franchise business. Clarify the Franchiees’ operation rights; redrafting the Rights and Limitations Clauses.

The “Test for Franchise Feasibility” Document must be completed using the parameters established in your review of the Franchise operation. Your ratings of the business readiness position required to establish a Franchise Operation will be based on the answers you develop for the Checklist Questions.

  • Assignments required to be uploaded:
    • The Checklist for The Basic Franchise Agreement
    • Test for Franchise Feasibility

GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

NO PLAGIARISM (100% Sure)

CLICK HERE TO MAKE YOUR ORDER  Restaurant’s long-range marketing plan, your company purchased property nationwide from the now-bankrupted “Sahara Desert Dish” franchise properties

TO BE RE-WRITTEN FROM THE SCRATCH

Categories
Writers Solution

Would you rather have a manager who regularly displayed a wide range of emotions and moods or one that showed little to no emotions or moods on a daily basis?

Start by reading and following these instructions:

1. Quickly skim the questions or assignment below and the assignment rubric to help you focus.

2. Read the required chapter(s) of the textbook and any additional recommended resources. Some answers may require you to do additional research on the Internet or in other reference sources. Choose your sources carefully.

3. Consider the discussion and any insights you gained from it.

4. Create your Assignment submission and be sure to cite your sources, use APA style as required, check your spelling.

Assignment: Answer these essay questions:

1. Would you rather have a manager who regularly displayed a wide range of emotions and moods or one that showed little to no emotions or moods on a daily basis? Explain how the difference in the two would affect how you handled the situation in which you had to tell that manager that your coworker has been sexually harassing you and another employee.

2. Research 3-5 high profile and successful business people who have been in the international news – both those famous for doing well and those famous for not doing well. Based on what you know of these people and what you’ve read, use the Big Five traits to write a short personality profile for each. Then explain how each personality fits – or does not fit – with that person’s business profile.

3. List the dominant work values you think the generation after the “Nexters” will have, and why. Include a solid rationale of why you think what you do, including a sound reflection on the dominant work values of the other generations in the figure.

4.  We all use shortcuts in making judgments about others. (I.e., assuming a woman in scrubs is a nurse, and a man in scrubs is a doctor.) As the world continues to get ‘flatter” and diversity increases do you think this will get better or worse? Why? How will you work to try to minimalize this in your own life? Include stories about a few times you have taken shortcuts to making judgments – either in your professional life or your personal life – and what the results were. Also share stories about times you were the one being judged and what the outcome of this was

GET SOLUTION BELOW

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
  • Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
  • Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
  • Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
  • Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
  • Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay. A verdict was rendered against three parent chaperones. How was the third parent included in the case?
  • Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services Would you rather have a manager who regularly displayed a wide range of emotions and moods or one that showed little to no emotions or moods on a daily basis?

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
Categories
Writers Solution

Create a Data Validation list in cell J7 based on the employee IDs located in the range A6:A25

After graduating from college, you and three of your peers founded the software company TechStore Unlimited (TSU). TSU provides an online market place that fosters business to business (B2B), business to consumer (B2C), and consumer to consumer sales (C2C). As one of the company’s principal owners, you have decided to compile a report that details all aspects of the business, including: employee payroll, facility management, sales data, and product inventory. To complete the task you will duplicate existing formatting, import data from an Access database, utilize various conditional logic functions, complete an amortization table, visualize data with PivotTables and Power Maps, connect and transform several external data sources, and lastly you will inspect the workbook for issues.

Start   Excel. Open 3rd Excel Exam SU1 2021.xlsx. Grader has automatically added   your last name to the beginning of the filename.

Create a Data Validation list in   cell J7 based on the employee IDs located in the range A6:A25. Add the Input   Message Select Employee ID and use the Stop Style Error Alert.
  Hint: Data Validation is located on the Data tab in the Data Tools group.
 

In cell K7, enter an INDEX   functions with two nested MATCH functions. The first MATCH function will look up the row number of the employee   number in cell J7 in the range A6:A25. The second MATCH function will look up the column number of the value   in cell K6 in the range B5:H5. Note   K6 contains a validation list that can be used to select various lookup   categories.
 

  Hint: The arguments of the INDEX are array (B6:H25), Row Number,Column   Number. The purpose of the two MATCH   functions is to look up the ROW number and COLUMN number. I suggest you do the first MATCH function   to ensure it works and then nest it inside of the INDEX function. Then nest the second MATCH function in the   INDEX function. To test the INDEX   function, use the Data Validation list in cell J7 to select Employee_ID 31461 and select Salary in cell K6. Did it   look up the correct salary for the specified employee number?
 

Click cell K11 and type FT. Click cell A28 and type Full Time   Employees.

Use the Format Painter to apply   the formatting from the cell A3 to the range A28:B28.
 

  Hint: The Format Painter is located on the
  Home tab in the Clipboard group.

 

Use Advanced Filtering to   restrict the data to only display FT employees based on the criteria in the   range K10:K11. Place the results in cell A29.
 

  Hint: Advanced Filtering is located on the Data tab in the Sort & Filter   group.
 

Enter a database function (DCOUNTA)   in cell K18 to determine the total number of FT employees. To complete the   function, use the range A5:H25 as the database argument, cell E5 for the   field, and the range K10:K11 for the criteria.
 

  Hint: To access DATABASE functions, click insert function, and select   Database from the function category menu.
 

Enter a database function in   cell K19 (DSUM) to determine the total value of FT employee salaries. To   complete the function, use the range A5:H25 as the database argument, cell H5   for the field, and the range K10:K11 for the criteria.
 

  Hint: To access DATABASE functions, click insert function, and select   Database from the function category menu.
 

Enter a database function   (DAVERAGE) in cell K20 to determine the average FT employee salary. To   complete the function, use the range A5:H25 as the database argument, cell H5   for the field, and the range K10:K11 for the criteria.
 

  Hint: To access DATABASE functions, click insert function, and select   Database from the function category menu.
 

Enter a database function in   cell K21(DMAX) to determine the highest FT salary. To complete the function,   use the range A5:H25 as the database argument, cell H5 for the field, and the   range K10:K11 for the criteria.
 

  Hint: To access DATABASE functions, click insert function, and select   Database from the function category menu.
 

Format the range K19:K21 with   Currency Number Format.
 

  Hint: Currency Number Format is located on the
  Home tab in the Number Group.

 

Use PowerQuery to connect and   open the Orders table in the eApp_Cap_Orders.accdb   database. Use the Query editor to format column A with Date number format and   load the table. Rename the worksheet Orders.
  Hint: Data can be imported using Get & Transform data tools located on   the Data tab in the Get & Transform data group.
 

Adapt the previous step to   connect and load the Warehouse table.
 

  Hint: Data can be imported using Get & Transform data tools located on   the Data tab in the Get & Transform data group.
 

Connect to, but don’t load the   Inventory table from the eApp_Cap_Orders.accdb   database. 

Create the following   relationships.
 

  Relationship 1
  Table Name
  Inventory
 

  Column (Foreign)
  Warehouse
 

  Table
  Warehouse
 

  Column (Primary)
  Warehouse
 

  Relationship 2
 

  Table
  Orders
 

  Column (Foreign)
 

  Item_Number
  Table
  Inventory
 

  Column (Primary)
 

  Item_Number
 

  Hint: Relationships are located on the Data tab in the Data Tools group.
 

Use PowerPivot to create a blank   PivotTable on a new worksheet. Add the following fields to the PivotTable.
  Rows
  Warehouse: Location
  Warehouse: Warehouse
  Inventory:
  Item_Number
  Values
  Inventory:
  Current_InventoryInventory:
  Total_Value

Insert a Slicer based on   Warehouse. Place the upper left corner of the Slicer inside the borders of   cell F3.
 

  Hint: Slicers are located on the Insert tab in the Filters group.
 

Create a 3D PowerMap that   displays the location of all warehouses based on the City geographic type.   Rename the worksheet Inventory.
  Hint: 3D Maps is located on the Insert tab in the Tours group.
 

Save and close the 3rd Excel   Exam SU1 2021. Go to the Test   Presentation Window. Upload the exam   and submit it for grading 

GET SOLUTION FOR THIS ASSIGNMENT

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
  • Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
  • Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
  • Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
  • Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
  • Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay. Create a Data Validation list in cell J7 based on the employee IDs located in the range A6:A25
  • Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services.

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays