solution

/in /by
The tea industry uses a continuous fermentation unit (CFU) that uses a conveying mechanism that moves slowly loaded with tea ready for fermentation. The fermentation process takes about 2 hours after which the tea proceeds to a drier. You are required to design a drive system for the CFU. This drive system is expected to receive power from a motor through a belt drive system that drives a gearbox that eventually drives the CFU. (1) Sketch schematic representation of this drive system Indicate, with explanations, some of the decisions to be made and factors to be considered in this design. Please note that actual computations are not necessary. (15 Marks)
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

/in /by

South-Eastern Ontario Collective (SEOC) is a performing arts organization that operates yearround and offers live in-person and on-line performances for the general public, but also special performances for students attending schools in South-Eastern Ontario. SEOC is revamping their information system and hired you to design a database that will hold information about SEOC past, current and future activities as well as information about the people involved in them. SEOC offers a creative platform for new and emerging artists and many of their productions need months of development and rehearsal work. Each of SEOC’s productions can be presented as “traditional” performances, in front of a paying audience, or as special presentations for local students. Each production has a title, an intended show format (e.g., in-person, on-line, etc.), a synopsis and a longer description destined to be included in the programs made available to audience members, a timeline, e.g., start and end date for its performance run, as well as a production development timeline, e.g., start and end date for its development. Each production has various tasks or roles, e.g., director, performer, composer, light designer, etc., that can be filled by artists and permanent staff, as appropriate. Each production involves at least one, and often more than one performer (artists who either full members of SEOC or hired sessional artists who work on a temporary basis), and at least one creator and one producer. The creator and the producer can be the same person, but often that is not the case. Each artist may be credited on a play as playing several different characters. Only the artists who are full members of SEOC can develop productions at SEOC. The sessional artists are all engaged for limited amounts of time. Note that an artist can work with SEOC on a temporary basis several times over the years, e.g., from March1 2019 to May 30 2019 and then again from May 1 2021 to October 31 2021, and work on multiple productions while under contract with SEOC. For each person involved in its productions, SEOC records the person’s SIN, first and last name, gender, address, one or more phone numbers and an email address and expertise. Some artists are actors, others are composers, and others have multiple areas of expertise, e.g., acting as well as directing. SEOC also employs permanent staff who work on various productions as sound engineers, light designers, costume designers, carpenters, etc. For each staff member SEOC needs to store their first and last name, address, SIN, email, phone number, permanent position (carpenter, costume designer, etc.) as well as their skills and qualifications. A permanent staff member may have a different role on each project they work on, as longs as their skills and qualifications match the requirements of the job role.

1.1 Draw an Entity-relationship diagram that models the information in the above description. Be sure to indicate all key and cardinality constraints and state in writing any assumptions that you make that are relevant for understanding your modeling decisions. Also identify in writing any constraints that you are unable to capture in the ER diagram. Use the style of modeling presented in class.

1.2 Translate your ER diagram into a relational model and identify the primary keys for each relation, as well as all foreign keys.

1.3 List 2 functional dependencies that should hold in any instance of your relational model.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

/in /by
Write a Feasibility / Recommendation Report
A suburb of Dallas, Texas, has been widening Stafford Street from two lanes to six lanes, and the First
Presbyterian Church on Stafford Street is greatly affected by the project. The church is losing quite a bit of
property, including part of the parking lot, for the street widening. Obviously, the church must replace the
parking lot and thus figured that this might be a good time to make some other changes they’ve been wanting to
make:
1. Reconfigure the parking lot to create more parking spaces and to ease the traffic flow.
2. Landscape the front of the church to make it more attractive.
3. Replace and move the church sign, which is plastic coated and will be too close to the street once it is
widened.
4. Add a porte cochere, which is a covered drive-thru for protection from rain and snow.
The Special Projects Committee, headed by Holly Sims, has been doing a feasibility study to see whether the
church should do more than just replace the parking lot. The committee is now ready to make a
recommendation to the pastor, David Kim, based on this preliminary data.
Directions
Read through the information on the next page and write a feasibility/ recommendation report that recommends
the first three projects. You will have to read through it and make sure the report follows a logical flow. Use the
reports in your book as guidelines.
? Use memo format. Keep your paragraphs short.
? Introduction: Write an introduction that identifies the project and previews the report. An introduction
includes the following three parts.
o Tells the purpose of the report.
o Describes the significance of the topic.
o Previews the main points in the order they will be developed.
? Facts and Finding Information
o Use headings to divide this main section into each of the four projects.
o Include the expenses and pledges in table format and refer to them in the report. It is easier for
the reader if a summary of the selected figures is in one location. Therefore, the expenses and
pledges should be a separate heading.
o Make sure you introduce the table and explain how it relates to the content in the document.
Do not assume the reader knows why it is there or what it means.
o The Summary of Expenses should be after you have explained your findings.
? Conclusions: Write a separate conclusions section. (See template.)
? Recommendations: Write a separate recommendations section. (See template.)
? Format guidelines:
o Headings are a sans serif font (Arial); text is a serif font (Times New Roman)
o Use single spaced, block style paragraphs.
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

/in /by

ONLY CALCULATE THE NET MARKETING CONTRIBUTION AND EVERYTHING AFTER IT!!!

PrinTechInc. has served the American market for 3D Printers for almost a decade. The company recently launched its Delta line of 3D Printers positioned for designing and fabricating small components and assemblies that fit within a variety of b2b type commercial and light-manufacturing operations within respective industries as needed.

The marketing team was allotted $7,500 for specific applied marketing research activities to gather intelligence on the viability of this Delta line. The stipulation was clear that this amount would be fully expensed during the first year itself if the Delta line made commercialization.

This did indeed happen, as the Delta line’s first year sales revenue closely matched their forecast.

The company manufactures these printers in their regular factory as a make-to-order batch production schedule timed to demand as per the orders brought in by their salesforce. The ready printers are packaged/labeled and moved as finished goods inventory to their distribution center where they track and dispatch respective orders of customers. A freight carrier thereupon picks up these printers from the distribution center and delivers to the respective customers.

A Delta 3D Printer is competitively priced at $5,000. They sold 200 units during the year. For each printer, the direct costs for procurement of the technical machineries & technological mechanisms, raw material, packaging/labeling, & labor that go into getting a printer ready for dispatch are estimated at 45% of the selling price.

The distribution center charges the company an inventory holding fee of $80 per month for the space that these packaged printers occupy in their holding facility prior to transit. The freight carrier company has negotiated a shipping cost of $50 for each of these Delta printers which it delivers from the distribution center to the ordering customers.

The salesforce allocation for this Delta line has been estimated at 15% of sales revenue.The company purchased a sales-territories-tracking module costing $3,000 dedicated to the Delta line for this sales team’s real-time usage on their enterprise information system as viewable on their tablets when in the field as well as in the office.

The sales team has been granted a limited cafeteria allowance of $2,500 total when in travel. The marketing communications group has developed a multi-touchpoints advertising & promotions plan for pushing the demand of this Delta line in their target markets. They bought a clipping service list worth $1,500 from a syndicated data source for determining the optimal message content to outlay in their ad campaign to effectively showcase this line. They run a print ad year-long in a major trade magazine for which the weekly rate is $165 per ad.

The Delta ad appears once every week & provides the needed visibility of the brand & this line.

The sales promotions allowance allocated for the Delta line is 3% of sales revenue, and the sales

The team is encouraged to push these promotions to stimulate clients’ spot interest & book the sale. The advertising group also engages in direct communications with several potential customers using client mailers specifying product information with pictorials & technical specifications to focus buyers’ attention. The budget for printing & posting these mailers is set at $4,000

For the first 6 months of the year, the company showcased this Delta line at the popularly visited Corporate Supplies Expo event held every month. They incurred a cost of $400 each month to conduct a booth at this Expo whereby they can develop utilizable leads, network with potential customers, & pitch to clients for further prospecting toward closing orders. Beyond all the above operating expenditures, the company has budgeted $120,000 for general & administrative functions to support this Delta product line, along with a $45,000 appropriation for indirect costs toward tooling, supplies, utilities, & maintenance purposes for the Delta line.

* Compute the ‘net marketing contribution’ for this Delta line.

* Compute the ‘marketing return-on- sales’ for this Delta line.
* Compute the ‘marketing return-on-investment’ for this Delta line

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"