W23-QBO- Case Study - Wk 4 - Class Practice C3 C7
doc
keyboard_arrow_up
School
George Brown College Canada *
*We aren’t endorsed by this school
Course
FIN2002
Subject
Accounting
Date
Apr 3, 2024
Type
doc
Pages
2
Uploaded by DeanCamel622
Week 4 - QuickBooks Lesson 3 & 7 Case Study 3: Da Silva Design
This case study is to develop your ability to complete the sales process (workflow). This includes setting up new customer, service item, invoicing, credit memo, receiving payments, and depositing funds from your customers. Objectives: After completing this case study activity, you will be able to:
Create new customer
Add new service item and inventory product items.
Record the delayed charge (sales order) and convert it to an invoice.
Record credit memo
Create an estimate and convert it to an invoice.
Enter payment received from customer.
Instruction:
1.
Login to QuickBooks online.
2.
Read the following case study.
3.
Complete all the Case Study Instructions listed below in the Da Silva Design company file.
4.
Upon completion, notify the instructor by submitting your QuickBooks login information to D2L Brightspace, Case Studies, Case Study 3
January 5th
Record sales order (Delayed Charge) and add new service and product inventory items
A new customer, InterContinental Hotel Group (
not a sub-customer
) send you a sales order (Delayed Charge) for Head Office (Category) – 30 hours of Interior Design Consultation (Sales/Price rate $250 per hour) and 50 Designer Vases (accessories) (Sales $100, Cost $50).
At January 1
st
, there were 200 designer vases in inventory with re-order point of 100. The services will
be provided by Da silva Design employees. These services will take place on Jan 8
th
.
Add new customer
InterContinental Hotel Group billing and shipping address is 1 rue des Carrieres, Quebec City, Quebec, G1R 4P5. The contact is Thomas Aubert whose phone number is 418-692-3861, email taubert@intercontinental.com
and website www.intercontinental.com/taubert.
InterContinental Hotel Group was given a $65,000 credit limit (notes), payment method is cheque, with payment terms of ‘Net 30’. They also negotiated a 15% ‘special price’ discount (price level decrease) for their order and will be charged HST (taxes).
January 10th
Create invoice for customer
The invoice was created and emailed to InterContinental Hotel Group The 30 designer vases were delivered to the customer. January 12
th
Create customer credit memo
InterContinental Hotel Group return two designer vases. They were broken in transit. A credit memo was emailed the same day to the customer.
January 17
th
Create an estimate
InterContinental Hotel Group had requested on estimate for interior designing their 1,000 suites and providing handmade red oak (straight grain) furniture. Rico DaSilva decided that they would need 3 red oak packs per suite (3,000 packs), labour would be 10 hours per suite (10,000 hours) and 150 hours of Interior Design Consultation.
At January 1
st
, there were 10,000 pack (25 board feet) red oak lumber in inventory with re-order point of 2,000, and category is Furniture. The sale price is $500 (pack) and cost $250 (pack). The Labour - Furniture sales price is $160 per hour, cost is $80 (service provided by Hughes Supplies Depot).
January 25
th
Turn the estimate into an invoice
InterContinental Hotel Group accepted the estimate. An invoice was sent out for 1/3 of the estimate.
January 31
st
Record customer payment receive and deposit
A cheque was received from InterContinental Hotel Group for the total amount owing for both invoices. It was deposited the same day. The accountant recorded the payment received and debited it to the Royal Bank - Chequing account.
Case Study Instructions:
1.
Setup the new customer InterContinental Hotel Group
2.
Setup the new service item and inventory product item.
3.
Setup price rule for 15% Special price discount.
4.
Create the ‘Delayed Charges’ form for the sales order.
5.
Record the Invoice from the Delayed Charges.
6.
Record the credit memo for the designer vases that were broken in transit.
7.
Setup the estimate feature and create the estimate and invoice for InterContinental Hotel Group.
8.
Record the payment received (total amount owing) from InterContinental Hotel Group
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Introduction to Marketing
Complete the following:
Choose 1 consumer product brand to be your âclientâ You may
choose any consumer brand or select a brand from this list
http://wwwbestglobalbrandscom/previous-years/2013
Review your clientâs brand by researching its Web site and
other supplemental resources, such as this directory to learn everything you
can about the company, its customers, the management team, and anything else
that will help you understand its brand
http://wwwhooverscom/
You are the chief marketing consultant for your companyâs
brand Your goal is to help the company create an updated marketing plan by
learning to apply the marketing process to communicate how great the companyâs
brand is to its current and potential customers in the marketplace and market
space
One of the first steps of the marketing plan is to
understand the business goals of the project The job of the marketer is…
arrow_forward
Brian just completed a Client Needs
Assessement and his client
confirmed that she will requre
profitability tracking, and need to
create budgets and purchase orders
in her accounting solution.
What is the mimimum Quick Books
online version suitable for Brian's
client?
arrow_forward
Match each of the following cost items with the value chain business function where you would expect the cost to be incurred:
Cost Item
1. Labor time to repair products under warranty
2. Radio commercials
3. Labor costs of delivering customer orders
4. Testing of competitor's product
5. Direct manufacturing labor costs
6. Development of order tracking system for online sales
7. Design cost of new product brochures
8. Hours spent designing childproof bottles
9. Training costs for representatives to staff the customer call center
10. Installation of robotics equipment in manufacturing plant
Business Function
arrow_forward
9
arrow_forward
Retail companies with today’s online, as well as in-store sales have a lot of data to keep track of!
Keeping track of sales, costs, and profits daily is essential to making the most of a business. This exercise illustrates how to use the skills presented in this Module to generate the data needed daily by a retail company.
Create the following calculated columns.
a) In I4, and J4, use a VLOOKUP function that will look up the Product Price and Product
Cost based on the Product Sold column which lists an ID number. [Hint: The Product Table
sheet lists the Price and Cost] If any error messages appear, check the Range Lookup.
b) In K4, use a formula to calculate Profit. Hint: Profit =(Product Price-Product
Cost)*Units Sold
Format columns I, J, and K as currency with two decimal places.
Make a copy of the Sales sheet and rename it Online Sales by Date. Place this sheet to the right of the Sales sheet. Answer the following question by filtering the data accordingly.
a) What was the…
arrow_forward
Ngai Nhung is the sales manager at Hung Technologies. At lunch with the company CEO, Ngai proudly announced that he had received a __ from a client. The client had just requested a large quantity of components from Hung.
A. purchase order
B. purchase requisition
C. back order
D. voucher
E. bill of lading
arrow_forward
Hello question is attached, thanks.
arrow_forward
What are the steps to create a new estimate in QuickBooks Online?
Projects > All Sales > New Transaction > Estimate
Sales > Customers > New Customer
Sales > All Sales > New Transaction > Estimate
Gear icon > Estimate
arrow_forward
Match each concept with its best description by entering its letter A through E in the blank. 1. Just-in-time manufacturing A. Focuses on quality throughout the production process. 2. Continuous improvement B. Flexible product designs can be modified to accommodate customer choices. 3. Customer orientation C. Every manager and employee constantly looks for ways to improve company operations. 4. Total quality management D. Reports on financial, social, and environmental performance. 5. Triple bottom line E. Inventory is acquired or produced only as needed.
arrow_forward
I need help.
arrow_forward
Before you begin this assignment review the Tying It All Together feature in the chapter.
Best Buy Co., Inc. is a leading provider of technology products. Customers can shop at more than 1,700 stores or online. The company is also known for its Geek Squad for technology services. Suppose Best Buy is considering a particular HDTV for a major sales item for Black Friday, the day after Thanksgiving, known as one of the busiest shopping days of the year. Assume the HDTV has a regular sales price of $900, a cost of $500, and a Black Friday proposed discounted sales price of $650. Best Buy’s 2015 Annual Report states that failure to manage costs could have a material adverse effect on its profitability and that certain elements in its cost structure are largely fixed in nature. Best Buy, like most companies, wishes to maintain price competitiveness while achieving acceptable levels of profitability. (Item 1A. Risk Factors.)
Requirements
Calculate the gross profit of the HDTV at the regular…
arrow_forward
Question 4.1
White Wizard Company makes golf equipment for retailers around the world. Below you will find a number of activities and cost at White Wizard Company.
Required:
Please list the activity as either, “Batch-level”, “Unit-level”, “Product-level”, “Customer-level” or “Organization-sustaining”.
Activity
Level
1)
A sales representative visits an old customer to check on how the company’s golf carts are working out and to try and make a new sale.
2)
A steering wheel is installed in a golf cart.
3)
The marketing department has a catalogue printed and then mails them to golf course managers.
4)
Completed golf carts are individually tested on the company’s test track.
5)
Molding and sanding each unit of product
6)
An outside lawyer draws up a new generic sales contract for the company, limiting Go Pro’s liability…
arrow_forward
Following are activities for a provider of online education. Classify each activity as unit level, batch level, service level, or
facility level.
Activity
1. Scheduling instructors
2. Controlling course data
3. Receiving supply shipments
4. Registering a student
5. Creating a new course
6. Maintaining course websites
7. Providing electricity
8. Delivering an online course
Level
arrow_forward
2. What specific suggestions would you make in terms of sales call allocation strategy for Brenda to make better use of available selling time in calling on these new accounts?
arrow_forward
View Policies
Current Attempt in Progress
E-Flix rents DVDS that are mailed out to customers upon demand. E-Flix has identified three activities involved in getting the videos to its
customers. Information on those activities for the month of July follows:
Estimated
Expected Use of
Cost Drivers
Cost Pools
Cost Drivers
Overhead Cost
Order taking costs
Number of orders
$20,592
187,200 orders
Technology support
Number of minutes
$11,700
234,000 minutes
Picking and shipping
Number of DVDS
$39,624
330,200 DVDS
costs
During July, the Tucker family placed 17 orders consisting of 21 DVDs. Tucker required 7 minutes of tech support. Customers pay $9.00 per
month to rent unlimited DVDS. Using ABC, how much overhead is applied to the Tucker family account for order taking costs?
O $4.74
O $2.52
O $1.871
O $6.45
Submit Answer
Save for Later
Attempts: 0 of 1 used
2:27 PM
10/13/20
e
arrow_forward
Customer protability, distribution. Best Drugs is a distributor of pharmaceutical products. Its ABC system has five activities:
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Related Questions
- Introduction to Marketing Complete the following: Choose 1 consumer product brand to be your âclientâ You may choose any consumer brand or select a brand from this list http://wwwbestglobalbrandscom/previous-years/2013 Review your clientâs brand by researching its Web site and other supplemental resources, such as this directory to learn everything you can about the company, its customers, the management team, and anything else that will help you understand its brand http://wwwhooverscom/ You are the chief marketing consultant for your companyâs brand Your goal is to help the company create an updated marketing plan by learning to apply the marketing process to communicate how great the companyâs brand is to its current and potential customers in the marketplace and market space One of the first steps of the marketing plan is to understand the business goals of the project The job of the marketer is…arrow_forwardBrian just completed a Client Needs Assessement and his client confirmed that she will requre profitability tracking, and need to create budgets and purchase orders in her accounting solution. What is the mimimum Quick Books online version suitable for Brian's client?arrow_forwardMatch each of the following cost items with the value chain business function where you would expect the cost to be incurred: Cost Item 1. Labor time to repair products under warranty 2. Radio commercials 3. Labor costs of delivering customer orders 4. Testing of competitor's product 5. Direct manufacturing labor costs 6. Development of order tracking system for online sales 7. Design cost of new product brochures 8. Hours spent designing childproof bottles 9. Training costs for representatives to staff the customer call center 10. Installation of robotics equipment in manufacturing plant Business Functionarrow_forward
- 9arrow_forwardRetail companies with today’s online, as well as in-store sales have a lot of data to keep track of! Keeping track of sales, costs, and profits daily is essential to making the most of a business. This exercise illustrates how to use the skills presented in this Module to generate the data needed daily by a retail company. Create the following calculated columns. a) In I4, and J4, use a VLOOKUP function that will look up the Product Price and Product Cost based on the Product Sold column which lists an ID number. [Hint: The Product Table sheet lists the Price and Cost] If any error messages appear, check the Range Lookup. b) In K4, use a formula to calculate Profit. Hint: Profit =(Product Price-Product Cost)*Units Sold Format columns I, J, and K as currency with two decimal places. Make a copy of the Sales sheet and rename it Online Sales by Date. Place this sheet to the right of the Sales sheet. Answer the following question by filtering the data accordingly. a) What was the…arrow_forwardNgai Nhung is the sales manager at Hung Technologies. At lunch with the company CEO, Ngai proudly announced that he had received a __ from a client. The client had just requested a large quantity of components from Hung. A. purchase order B. purchase requisition C. back order D. voucher E. bill of ladingarrow_forward
- Hello question is attached, thanks.arrow_forwardWhat are the steps to create a new estimate in QuickBooks Online? Projects > All Sales > New Transaction > Estimate Sales > Customers > New Customer Sales > All Sales > New Transaction > Estimate Gear icon > Estimatearrow_forwardMatch each concept with its best description by entering its letter A through E in the blank. 1. Just-in-time manufacturing A. Focuses on quality throughout the production process. 2. Continuous improvement B. Flexible product designs can be modified to accommodate customer choices. 3. Customer orientation C. Every manager and employee constantly looks for ways to improve company operations. 4. Total quality management D. Reports on financial, social, and environmental performance. 5. Triple bottom line E. Inventory is acquired or produced only as needed.arrow_forward
- I need help.arrow_forwardBefore you begin this assignment review the Tying It All Together feature in the chapter. Best Buy Co., Inc. is a leading provider of technology products. Customers can shop at more than 1,700 stores or online. The company is also known for its Geek Squad for technology services. Suppose Best Buy is considering a particular HDTV for a major sales item for Black Friday, the day after Thanksgiving, known as one of the busiest shopping days of the year. Assume the HDTV has a regular sales price of $900, a cost of $500, and a Black Friday proposed discounted sales price of $650. Best Buy’s 2015 Annual Report states that failure to manage costs could have a material adverse effect on its profitability and that certain elements in its cost structure are largely fixed in nature. Best Buy, like most companies, wishes to maintain price competitiveness while achieving acceptable levels of profitability. (Item 1A. Risk Factors.) Requirements Calculate the gross profit of the HDTV at the regular…arrow_forwardQuestion 4.1 White Wizard Company makes golf equipment for retailers around the world. Below you will find a number of activities and cost at White Wizard Company. Required: Please list the activity as either, “Batch-level”, “Unit-level”, “Product-level”, “Customer-level” or “Organization-sustaining”. Activity Level 1) A sales representative visits an old customer to check on how the company’s golf carts are working out and to try and make a new sale. 2) A steering wheel is installed in a golf cart. 3) The marketing department has a catalogue printed and then mails them to golf course managers. 4) Completed golf carts are individually tested on the company’s test track. 5) Molding and sanding each unit of product 6) An outside lawyer draws up a new generic sales contract for the company, limiting Go Pro’s liability…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageAccounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning