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 |
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
