26 Mar The files you create while completing the Integrated Word/Excel problem. Please complete this PDF and send all the Word/Excel fi
The files you create while completing the Integrated Word/Excel problem.
Please complete this PDF and send all the Word/Excel files.
Sheet1
| Product # | Description | Price |
| 3550 | Licorice Candy | $18.00 |
| 3551 | Cinnamon Burst | $15.00 |
| 3552 | Red Pepper Surprise | $12.00 |
| 3553 | Lemongrass | $17.00 |
| 3554 | Coconut Chai | $18.00 |
| 3555 | Vanilla Apple | $16.00 |
| 3556 | Lemon Spearmint | $15.00 |
| 3557 | Juniper | $14.00 |
| 3558 | Eucalyptus | $16.00 |
| 3559 | Ginger Punch | $18.00 |
| 3560 | Lovely Lavender | $12.00 |
| 3561 | Guava | $16.00 |
| 3562 | Goji Berry | $14.00 |
| 3563 | Citrus Pop | $19.00 |
| 3564 | Mango Fruit | $12.00 |
| 3565 | Mulberry Chamomile | $14.00 |
| 3566 | Soothing Chamomile | $13.00 |
| 3567 | Spearmint Remedy | $15.00 |
| 3568 | Myrtle | $18.00 |
| 3569 | Peppermint Surprise | $16.00 |
| 3570 | Wintergreen | $17.00 |
| 3571 | Raspberry Rooibos | $12.00 |
| 3572 | Strawberry Hibiscus | $13.00 |
| 3573 | Rosehip | $12.00 |
| 3574 | Fennel | $15.00 |
| 3575 | Apricot Taste | $19.00 |
,
Quarter 3
| Harmony Teas | ||||
| Sales Projection | ||||
| July | August | September | Total | |
| Revenue | ||||
| Black and Green Teas | $ 2,800.00 | $ 3,080.00 | $ 3,388.00 | $ 9,268.00 |
| Herbal Teas | $ 5,000.00 | $ 5,500.00 | $ 6,050.00 | $ 16,550.00 |
| Total Revenue | $ 7,800.00 | $ 8,580.00 | $ 9,438.00 | $ 25,818.00 |
| Expenses | ||||
| Advertising | 1,500.00 | 1,500.00 | 1,500.00 | 4,500.00 |
| Cost of Sales: 60% | 4,680.00 | 5,148.00 | 5,662.80 | 15,490.80 |
| Total Expenses | $ 6,180.00 | $ 6,648.00 | $ 7,162.80 | $ 19,990.80 |
| Net Revenue | $ 1,620.00 | $ 1,932.00 | $ 2,275.20 | $ 5,827.20 |
Projected Sales
| Qtr 1 | Qtr 2 | Qtr 3 | Qtr 4 | |
| Geen & Black Teas | $ 2,500.00 | $ 3,300.00 | $ 12,000.00 | $ 7,200.00 |
| Herbal Teas | $ 2,800.00 | $ 4,800.00 | $ 17,000.00 | $ 11,000.00 |
,
Harmony Teas has an opportunity to partner with Capilano Inn, a boutique-style hotel that has just opened in Vancouver and is interested in offering its guests premium quality teas. This report describes the partnership issues in terms of three factors: Partnership Requirements, Products and Services, and Financial Considerations.
This section provides background information about Capilano Inn and discusses how the partnership could benefit both companies.
Capilano Inn has made steady progress in a receptive marketplace. The boutique-style hotel caters to guests with discerning tastes who want a luxury experience in a small and intimate setting. Capilano Inn’s planet friendly ethos has led the owners to seek out distributors and other related companies with similar commitments to the environment.
Capilano Inn wishes to work with a local distributor that provides high quality gourmet tea products that are organically grown and presented in environmentally sensitive packaging. Harmony Teas can certainly supply teas of the required quality.
PRODUCTS AND SERVICES
This section discusses the proposed partnership in terms of the products that Harmony Teas will provide to Capilano Inn.
Products Available from Harmony Teas
The inn plans to feature a selection of herbal teas in each guest room in addition to promoting the teas in its restaurant. Capilano Inn also has plans for launching a biweekly Afternoon Tea service that will feature only teas from Harmony Teas.
Capilano Inn is most interested in the herbal teas shown below.
Capilano Inn has provided information related to the sales of products it received from its former distributor, The Tea Place. Based on this information, Harmony Teas could expect a minimum 20% increase in revenues on the sale of products to Capilano Inn.
Shown below are projected sales of Harmony Teas to Capilano Inn over the three busiest months of the tourist season.
The chart illustrated below shows the revenues projected for each quarter in the first year of the proposed partnership with Capilano Inn.
Harmony Teas has the opportunity to increase its market share by partnering with Capilano Inn. Both companies are seriously committed to the environment and to providing their customers with a high-quality tea drinking experience.
,
Team Project
Project Summary
In the appropriate area of the table below, enter your name and write a description (up to 200 words) about the skills you’ve practiced while completing the Team Project. List a selection of the skills you used to create the file or files assigned to you, then comment on any challenges you experienced with specific skills and how you solved them. For example, if you experienced difficulties creating queries in Access, describe the issues and what you did to fix them.
Team Member 1
|
Name |
|
|
Description |
Team Member 2
|
Name |
|
|
Description |
Team Member 3
|
Name |
|
|
Description |
,
Desert Jazz Festival
205 Sunset Drive, Phoenix, AZ 85007
www.desertjazzfestivalphoenix.com
Current Date
[Address]
[Greeting]
[Band Name] is scheduled to perform on [Performance Date] at [Performance Time] in the [Venue]. The total pay for the performance is [Pay].
Please confirm as soon as possible the availability of [Band Name] to perform in the festival.
As soon as I receive your confirmation, I will send you additional information about accommodations, equipment options, and other information related to making your experience at the Desert Jazz Festival a positive one.
I look forward to meeting you.
Sincerely,
[Your Name]
,
Artist |
Painting Title |
Creation Date |
Medium |
Dimensions |
Cost |
Price Category |
|
Sharon Leitz |
Waves |
2017 |
Oil on canvas |
55" x 44" |
$3000 |
Mid Range |
|
Mike Eng |
Morning Stroll |
2016 |
Acrylic on panel |
16" x 20" |
$800 |
Budget |
|
Ari Khosani |
Two Hands |
2016 |
Bronze casting |
24" high |
$7000 |
Premium |
|
Peter Jonson |
Ocean Swells |
2017 |
Acrylic on canvas |
55" x 70" |
$2500 |
Mid Range |
|
Carlos Vasquez |
Moon Rise |
2017 |
Oil on canvas |
45" x 30" |
$1200 |
Budget |
|
Jatinder Singh |
Sunset |
2017 |
Acrylic on paper |
20" x 28" |
$600 |
Budget |
|
Emma Fraser |
Larks |
2016 |
Oil on canvas |
40" x 48" |
$3000 |
Mid Range |
|
Nina Schwartz |
Meadow Scene |
2015 |
Watercolor |
18" x 22" |
$900 |
Budget |
|
Hiro Ito |
Green Scream |
2016 |
Oil on panel |
18" x 24" |
$2500 |
Mid Range |
|
Gary Nova |
Striated |
2017 |
Acrylic on canvas |
56" x 72" |
$6000 |
Premium |
|
Ruby Grayson |
Seastrand |
2016 |
Acrylic on canvas |
36" square |
$2000 |
Mid Range |
|
Francesco Salvini |
On the Level |
2017 |
Oil on canvas |
64" x 82" |
$2500 |
Mid Range |
|
Takao Watanabe |
Wild Ones |
2016 |
Ink on paper |
26" x 30" |
$3000 |
Mid Range |
|
Simon Kowalski |
Daunted |
2016 |
Oil on canvas |
72" x 96" |
$7000 |
Premium |
|
Darryl Gleeson |
Ancestors |
2016 |
Collage |
14" x 18" |
$1000 |
Budget |
,
Performances
| ID | Performance Date | Performance Time |
| 1 | 10/15/17 | 2:00:00 PM |
| 2 | 10/15/17 | 2:00:00 PM |
| 3 | 10/15/17 | 8:00:00 PM |
| 4 | 10/15/17 | 8:00:00 PM |
| 5 | 10/16/17 | 2:00:00 PM |
| 6 | 10/16/17 | 8:00:00 PM |
| 7 | 10/16/17 | 8:00:00 PM |
| 8 | 10/16/17 | 8:00:00 PM |
| 9 | 10/17/17 | 2:00:00 PM |
| 10 | 10/17/17 | 8:00:00 PM |
,
| ID | Band Name | Leader First Name | Leader Last Name | Address | City | State | Zip | Phone | Pay |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Aya Ramirez Quartet | Aya | Ramirez | 62 Western Drive | Los Angeles | CA | 90004 | 3235556789 | ¤ 1,200.00 |
| 2 | Lonnie Watson Trio | Lonnie | Watson | 1098 Culvert Drive | Culver City | CA | 90232 | 8185557890 | ¤ 5,500.00 |
| 3 | The Jazz Gals | Lisa | Delgrasso | 789 Sunset Street | Phoenix | AZ | 85006 | 6025554311 | ¤ 2,000.00 |
| 4 | Jazz Giants | Gary | Renfrew | 29 Jonson Street | Phoenix | AZ | 85009 | 6025554433 | ¤ 2,500.00 |
| 5 | Uma Schwartz Quartet | Uma | Schwartz | 90 Long Road | Scottsdale | AZ | 85256 | 5205554300 | ¤ 1,200.00 |
| 6 | Kit Quinn Quartet | Kit | Quinn | 18 Cactus Drive | Mesa | AZ | 95205 | 4805551266 | ¤ 1,800.00 |
| 7 | Paul Cramer Orchestra | Paul | Cramer | 1908 Venice Drive | Malibu | CA | 90265 | 3105557223 | ¤ 3,000.00 |
| 8 | The Sutton Swingers | Chuck | Suttton | 178 Main Drive | Denver | CO | 80208 | 3035553455 | ¤ 3,000.00 |
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.