No plagiarism otherwise I will not accept the answer

HI Tutors, I need helps with this question. The complete case question is attached below.

The town of Easley, South Carolina, has experienced tremendous growth over the past few years. After a long and spirited discussion, the town council has unanimously decided to build Easley's first big shopping center. On the recommendation of the town planner, Jimmy Barnes, the council has decided to hire the Ray Development Company (RDC) to help in the shopping center's planning and construction. RDC has a great deal of experience in building malls and shopping centers in the southeastern U.S, and the town council is confident they will help Easley identify the right stores for its new shopping center.

Jennifer Ray, president of RDC, has quickly identified and signed two major anchor stores as well as several other attractive tenants for the shopping center. After assigning suitable spaces to these tenants, Jennifer has 32,000 square feet of space still available for allocation. She and Jimmy are now tasked with deciding which stores to locate in this available space. Due to the significant market interest in Easley's new shopping center, Jennifer and Jimmy are confident that they will not have any trouble finding tenants to suit whatever allocation plan they decide to use.

After extensive study, Jennifer has drawn up a list of 20 different stores she thinks she and Jimmy should consider for the available space. Table 9 below lists these stores in alphabetical order, along with the floor space required by each store, the annual rent the store would pay for the space, the expected annual sales at the store and the expected upfit cost to renovate the allotted space to make it suitable for the store.

As per the leasing agreement developed by RDC, each store would pay the town an annual rent for its allotted space. The town council has mandated that the total rent payments each year must be sufficient to cover the annual fixed cost of maintaining the shopping center. This cost, which includes items such as security, janitorial services, maintenance and utilities, is estimated to be $500,000 per year. In addition, the town council has specified that the total upfit amount spent on renovating the space to suit these stores cannot exceed 60% of the actual total annual rent that would be collected.

In order to make the shopping center attractive to a broad range of customers, Jennifer believes it must adhere to certain conditions in terms of the mix of stores. Taking into account the tenants that have already been signed for the shopping center, she thinks the remaining space should contain at least two stores each in the apparel, food and specialty types and at least one store each in the housewares and services types. She also thinks that there should be no more than three stores of any type and that the number of food and services stores should not exceed the total number of stores in the other three types.

RDC has proposed an arrangement under which the town would receive a fixed percentage of the total annual sales generated by the stores. The town council therefore wants to identify the solution that would generate the maximum total sales from these stores.

Requirements:
1. Create a spreadsheet model for this problem and solve it to determine the optimal solution.
2. Can you recommend an alternate plan to Jennifer's that would maximise total sales from the stores? Provide support for your answer.

 

2nd Assignment

how can i answer the following?:Assignment 2: Educational WebsiteInstructions: For the purpose of marking this assignment (2), you are required to perform the tasks as set out in the Word document W_CH01_GOV1_H3_Instructions.docxProject Description: In the following project, you will edit a handout that describes a new educational website product that Sturgeon Point Productions has developed for instructors. You will insert text, insert and format graphics, insert and modify text boxes and shapes, change document and paragraph layout, create lists, set and modify tab stops, and insert a SmartArt graphic.Instructions: For the purpose of grading the project you are required to perform the following tasks: StepInstructionsPoints Possible1Start Word. Download and open the file named go_w01_grader_h3.docx.02Type Educational Websites and then press ENTER. Type Sturgeon Point Productions is offering website tie-ins with every educational video title in our catalog, at no additional cost. After the period, press SPACEBAR. Insert the text from the grader data file go_w01_grader_h3_Education.docx.43Change the Line Spacing for the entire document to 1.5 and the spacing After to 6 pt. To each of the four paragraphs that begin Sturgeon Point Productions, As educators, When submitting, and The video, apply a First Line indent of 0.5".64Change the font size of the title to 50 and the title Line Spacing to 1.0. Center the title. From the Text Effects and Typography gallery, apply the second effect to the title—Fill - Blue, Accent 1, Shadow.105At the beginning of the paragraph below the title, insert the picture downloaded with your grader files—go_w01_grader_h3_Media.jpg. Change the picture Height to 2, and the Layout Options to Square. Format the picture with a 10 Point Soft Edges effect.86Use the Position command to display the Layout dialog box. Change the picture position so that the Horizontal Alignment is Right relative to the Margin. Change the Vertical Alignment to Top relative to the Line.47Select the five paragraphs beginning with Historic interactive timelines and ending with Quizzes and essay exams, and then apply checkmark bullets.58Locate the paragraph below the bulleted list and then click after the colon. Press ENTER and remove the first line indent. Type a numbered list with the following three numbered items:The title in which you are interestedThe name of the class and subjectOnline tools you would like to see created59With the insertion point located at the end of the numbered list, insert a Basic Chevron Process SmartArt—under Process, in the fifth row, the second layout. In the first shape, type View. In the second shape type Interact and in the third shape type Assess. Select the outside border of the SmartArt. Change the SmartArt color to Colorful Range - Accent Colors 4 to 5, and then apply the 3-D Flat Scene style.810Change the Height of the SmartArt to 1 and the Width to 6.5. Change the SmartArt Layout Options to Square, the Horizontal Alignment to Centered relative to the Page, and the Vertical Alignment to Bottom relative to the Margin.811Select the days and times at the end of the document and then set a Right tab with dot leaders at 6".412Click in the blank line below the tabbed list, and then center the line. Insert an Online Video. Search YouTube for Pearson Higher Education Learning, and then insert the first video that displays. Change the video height to 1.5.413Below the video, insert a Rounded Rectangle shape. Change the Shape Height to 1.5 and the Shape Width to 6.5. Display the Shape Styles gallery and in the fourth row, apply the second style— Subtle Effect - Blue, Accent 1.814Use the Position command to display the Layout dialog box, and then change the position so that both the Horizontal and Vertical Alignment are Centered relative to the Margin. In the rectangle, type Sturgeon Point Productions and then press ENTER. Type Partnering with Educators to Produce Rich Media Content and then change the font size to 16.615Move to the top of the document and insert a Text Box above the title. Change the Height of the text box to 0.5 and the width to 3.6.Type Sturgeon Point Productions and then change the font size to 22. Center the text.216Use the Position command to display the Layout dialog box, and then position the text box so that the Horizontal Alignment is Centered relative to the Page and the Vertical Absolute position is 0.5 below the Page.617Change the text box Shape Fill color to Blue, Accent 5, Lighter 80%. Change the Shape Outline to the same color—Blue, Accent 5, Lighter 80%.418Deselect the text box. Apply a Box setting page border and choose the first style. Change the Color to Blue, Accent 5.419Change the Top margin to 1.25 and insert the File Name in the footer.420Save and close the document. Exit Word. Submit the file as directed.0 Total Points100

3rd Assignment

i need help on my database project :

Consider the important concepts described in the following scenario:

• A salesperson may manage many other salespeople. A salesperson is managed by only one salespeople. A salesperson can be an agent for many customers.
• A customer is managed by one salespeople. A customer can place many orders. An order can be placed by one customer. An order lists many inventory items. An inventory item may be listed on many orders.
• An inventory item is assembled from many parts. A part may be  assembled into many inventory items. Many employees assemble an inventory item  from many parts. A supplier supplies many parts. A part may be supplied by many  suppliers.

The deadline to submit the project is 10/04/2016.

 

1. Design the database, following an ER model.                                   (2 Points)                        
2. Normalize the tables ( each table should be in 3NF at least)            (2 Points)
3. Use MySQL to create the normalized tables.                                    (2 Points)
4. Populate your tables with 5 rows at least.                                         (2 Points)           
5. Execute the requested queries.                                                           (2 Points)

 

Final Deliverables:

 

A Word document to be submitted by each students that should contain:

 

1. The an ER diagram for the database.                                                      
2. The normalization process. (show each table in 1NF, 2NF, 3NF)         
3. SQL statements for creating tables and inserting data.                          
4. A screen shots for every created table and its data.                                  
5. SQL queries and their results.                                                                 
6. A screen shots for every query and its result. 

ComputerScienceExpert

(11)

Status NEW Posted 23 May 2017 01:05 AM My Price 9.00

-----------

Attachments

file 1495502121-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer