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 Questions
1. Show the Monthly Sales Plan of Shopee (please use graphical representation for data visualization)
Use this examples:
January: New Year promotions, kick-off sales meetings.
February: Valentine's Day promotions, lead nurturing activities.
March: End of Q1 push, performance review, and strategy adjustment.
April: Spring sales campaign, customer feedback collection.
May: Mid-year training, product refresh.
June: Mid-year performance review, prepare for summer promotions.
July: Summer sales push, lead generation activities.
August: Back-to-school promotions, focus on upselling.
September: End of Q3 push, prepare for Q4 strategy.
October: Fall sales campaign, early holiday promotions.
November: Black Friday and Cyber Monday sales.
December: Holiday sales, year-end clearance, customer appreciation events.
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
please answer within 30 minutes.
arrow_forward
question in photo plz
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
newconnect.mheducation.com
y!
Module 5
My Solutions | bartleby
Course Modules: Accounting in a Corporate Environment (2020 Spring)
Module 5 i
Saved
Help
Save & Exit
Submit
All
Unread
Check my work
3.
Search Reading List
Logistics Solutions provides order fulfillment services for dot.com merchants. The company maintains warehouses that stock
items carried by its dot.com clients. When a client receives an order from a customer, the order is forwarded to Logistics
Solutions, which pulls the item from storage, packs it, and ships it to the customer. The company uses a predetermined
variable overhead rate based on direct labor-hours.
10
points
In the most recent month, 195,000 items were shipped to customers using 8,600 direct labor-hours. The company incurred a
total of $30,530 in variable overhead costs.
According to the company's standards, 0.04 direct labor-hours are required to fulfill an order for one item and the variable
overhead rate is $3.60 per direct labor-hour.
еВook
Required:…
arrow_forward
Make a textual information from this Enrollment by Key Stage
arrow_forward
Please see below.
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
Give answer within 45 min I will give you up vote
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
1. Journal all transactions in Part One 2. Using the chart of accounts, open ledger accounts and post journals to the ledger account. 3. Prepare a trial balance 4. Prepare the following statements: 1. Income Statement 2. Retained Earnings Statements 3. Balance Sheet You need to use Microsoft Excel. Do not use Google Docs or Apple’s numbers. Place your submission in the appropriate journal labeled final project in the learning modules tab in Blackboard. The project is due in Module 15. Three points extra credit to final grade if submitted during Module 14. Part One A. The following transaction occurred for Scrooge Inc. for the month of December 31, 1820. B. Ebenezer Scrooge invested $50,000 cash along in the company in exchange for common stock. C. The company prepaid $500 for 12 month’s rent. D. The company purchased $100 in office supplies. Payment due withing 10 days E. Scrooge Inc. completed services for a client and immediately received $2,000. F. The company completed $1,500…
arrow_forward
Cs Cases
1. Create a new Excel sheet in which you will find the delivery cost for each delivery.
nal...
a. Create a new sheet that has information for each delivery. Name this sheet "lookup."
Rat...
b. In this lookup sheet, look up the hourly rate for the driver for each delivery. Do not enter this information manually! Use the VLOOKUP function.
c. For each delivery, calculate the delivery cost as hourly rate for the driver multiplied by time (hours).
Fill in the table below for the first ten records.
Date
Delivery ID
Driver
Time (Hours)
Hourly Rate
Cost
20.00 X
1
George
1
1/1
25.00 X
2
Deanna
1.5
1/2
2
3
Ben
1/3
4
Caroline
2
1/3
<
5
Unknown
1
1/4
6
Elizabeth
2
1/5
7
Unknown
2.5
1/5
8
Unknown
1
1/6
9
Adam
2
1/8
10
Hannah
1.5
1/9
2. Create a new Excel sheet that aggregates the data contained in the lookup sheet to show each driver's activity analysis.
a. Create a pivot table in a new sheet; name this new sheet "pivot table."
arrow_forward
Please answer multichoice question in photo. There can be more than one answer.
arrow_forward
Identify which department has stewardship (having the job of supervising or taking care of) over the following journals, ledgers, and files. (Please be reminded of the Honor Pledge written in your answer sheet.) 1. Customer open order file
2. Sales journal 3. Journal voucher file
4. Cash receipts journal 5. Inventory subsidiary ledger 6. Accounts receivable subsidiary ledger 7. Sales history file 8. Shipping report file 9. Credit memo file10. Sales order file11. Closed sales order file
PreviousNext
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
Please help with the income statement based on info below:
Pricing
Actual #
Revenue
Grooming
25
4
3,000
Daycare
18
22
11,880
Boarding
25
12
9,000
Total January Revenue
23,880
arrow_forward
Create a flowchart for the following telephone-ordering process at a retail chain that specializes in selling books and music CDs. It provides an ordering system via the telephone to its time-sensitive customersbesides its regular store sales. First, the automated system greets customers and identifies whether they have a tone or pulse phone. Customers choose 1 if they have a tone phone; otherwise, they wait for the first available service representative to process their request. If customers have a tone phone, they complete their request by choosing options on the phone. First, the system checks to see whether customers have an existing account.Customers choose 1 if they have an existing account or choose 2 if they want to open a new account. Customers wait for the service representative to open a new account if they choose 2. Next, customers choose between the options of making an order, canceling an order, or talking to a customer representative for questions and/or complaints. If…
arrow_forward
Home
* CengageNOWv2 | Online teachin x
+.
takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
eBook
Show Me How
E Print Item
Flexible Budget for Selling and Administrative Expenses for a Service Company
Digital Solutions Inc. uses flexible budgets that are based on the following data:
Sales commissions
8% of sales
Advertising expense
15% of sales
Miscellaneous administrative expense
$10,000 per month plus 4% of sales
Office salaries expense
$50,000 per month
Customer support expenses
$20,000 per month plus 30% of sales
Research and development expense
$75,000 per month
Prepare a flexible selling and administrative expenses budget for October for sales volumes of $500,000, $750,000, and $1,000,000. (Use Exhibit 5 as a model.)
Digital Solutions Inc.
Flexible Selling and Administrative Expenses Budget
For the Month Ending October 31
Total sales
$500,000 $750.000 $1,000,000
Variable cost:
Sales commissions
Advertising expense
Miscellaneous…
arrow_forward
Describe how you can use QuickBooks to perform the following tasks
Carry out transfers between accounts
Delete a Connected Bank Account
Create a Budget Sorted by Customer and Service Item
Enter a bill for inventory part
arrow_forward
PLEASE USE EXCEL ON ANSWERING THE QUESTIONS. MAKE SURE TO TAKE A SCREENSHOT STEP BY STEP OF HOW YOU DID THE SOLUTIONS IN EXCEL. ANSWER THIS COMPLETELY TO GET AN UPVOTE. I POSTED A LOT OF THIS, IF YOU SEE THIS AGAIN, YOU CAN SEND THE SAME SOLUTIONS, I WILL STILL UPVOTE DO NOT WORRY, JUST GIVE ME THE CORRECT SOLUTIONS AND ANSWERS.
I REPEAT, ONLY EXCEL
arrow_forward
Please draw balance scorecard.
arrow_forward
QUESTION 3
The following type of marketing involves sending out mails, fliers, testers, and DVDs to consumers?
a. Direct-response marketing
b. Direct-mail marketing
c. Direct-mobile marketing
d. Kiosk marketing
e. Online marketing
arrow_forward
Hope you can answer this with the right format. Please provide a picture also so that i can understand. Thankyou!
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher: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
Related Questions
- 1. Show the Monthly Sales Plan of Shopee (please use graphical representation for data visualization) Use this examples: January: New Year promotions, kick-off sales meetings. February: Valentine's Day promotions, lead nurturing activities. March: End of Q1 push, performance review, and strategy adjustment. April: Spring sales campaign, customer feedback collection. May: Mid-year training, product refresh. June: Mid-year performance review, prepare for summer promotions. July: Summer sales push, lead generation activities. August: Back-to-school promotions, focus on upselling. September: End of Q3 push, prepare for Q4 strategy. October: Fall sales campaign, early holiday promotions. November: Black Friday and Cyber Monday sales. December: Holiday sales, year-end clearance, customer appreciation events.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_forwardplease answer within 30 minutes.arrow_forward
- question in photo plzarrow_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
- newconnect.mheducation.com y! Module 5 My Solutions | bartleby Course Modules: Accounting in a Corporate Environment (2020 Spring) Module 5 i Saved Help Save & Exit Submit All Unread Check my work 3. Search Reading List Logistics Solutions provides order fulfillment services for dot.com merchants. The company maintains warehouses that stock items carried by its dot.com clients. When a client receives an order from a customer, the order is forwarded to Logistics Solutions, which pulls the item from storage, packs it, and ships it to the customer. The company uses a predetermined variable overhead rate based on direct labor-hours. 10 points In the most recent month, 195,000 items were shipped to customers using 8,600 direct labor-hours. The company incurred a total of $30,530 in variable overhead costs. According to the company's standards, 0.04 direct labor-hours are required to fulfill an order for one item and the variable overhead rate is $3.60 per direct labor-hour. еВook Required:…arrow_forwardMake a textual information from this Enrollment by Key Stagearrow_forwardPlease see below.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 > Estimatearrow_forwardGive answer within 45 min I will give you up votearrow_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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher: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