October 30, 2016

Body Shop Department – Sales & Gross Profit

Financial Statement Preparation

BODY SHOP DEPARTMENT – SALES & GROSS PROFIT
Click on the highlighted areas and a description will appear in a new window. Clicking on an account number will take you to the appropriate page in this manual.
2021 2020 – Page 5 – Body Shop Department Sales and Gross Profit
Gross % Sales Repair Order Analysis - Franchise Only Sales Per Repair Order - Parts/Labor Wholesale 'S' Wholesale 'G' Counter Retail 'S' Counter Retail 'G'

Gross % Sales

Each Body Shop gross account is to be divided by each corresponding sales account and recorded in the Month and YTD columns. For example, (3.94 = 3.9%) Carry % to one place beyond decimal

Repair Order Analysis - Franchise Only

Traffic Repair Count: A single Order that contains sales in more than one of the four categories should be included in each of the appropriate Traffic Count entries. As a result, the total Traffic Count will usually exceed the number of repair orders written. For example, one Repair Order might reflect sales of Parts: Repair Shop as well as sales of Parts: Body Shop. Therefore, the Traffic Count column would include "I" on the Repair Shop line and also "I" on the Body Shop Line

Sales Per Repair Order - Parts/Labor

Divide the Traffic count, which is recapped from the Parts & Service Sales, Journal, into total dollar Parts?Labor sales recorded in the Parts and Service or Body Shop sections of the financial statement

Wholesale 'S'

Selling price of other Franchise parts sold to customers generally recognized as wholesale, such as fleet owners, and insurance companies Account #05401 sales

Wholesale 'G'

Gross - Sales less Cost of Sales (inventory value of parts sold) Account #60401, and 06411 parts wholesale Job Incentive

Counter Retail 'S'

Selling price of other Franchise parts sold over the counter to retail customers Account #05421

Counter Retail 'G'

Gross - Sales less Cost of Sales Other Franchise parts sold over the counter Account #06421

Gross % of Sales Sales per R.O. Franchise R.O. Analysis Wholesale 'S' Wholesale 'G' Counter Retail 'S' Counter Retail 'G' Body Shop (Metal) Body Shop (Paint) Warranty & Policy Claims (Body Shop) 'S' Internal (body Shop) 'S' Unapplied Time Sublet Repairs Materials Parts Sales Body-Oth Franshise Total Departments 'S' Total Departments 'G' Total