Lacob Sports Medicine, Inc., offers two types of physical exams for students: the basic physical and the extended physical. The charge for the basic physical is $85, while the charge for the extended physical is $160. Lacob expects to perform 225 basic physicals and 165 extended physicals in July, 245 basic and 210 extended in August, and 85 basic and 65 extended in September.
Prepare the sales budget for the second quarter (July through September) with a column for each month and for the quarter in total.
Complete the sales budget one step at a time.
Lacob Company |
|||||||
Sales Budget |
|||||||
For the Months of July through September |
|||||||
July |
August |
September |
Quarter |
||||
Number of exams performed (basic) |
|||||||
Multiply by: Price per exam |
|||||||
Sales revenue (basic) |
Number of exams performed (extended) |
||||
Multiply by: Price per exam |
||||
Sales revenue (extended) |
Total sales revenue |
The answer has been presented in the supporting sheet. All the parts has been solved with detailed explanation and calculation. For detailed answer refer to the supporting sheet.
Lacob Sports Medicine, Inc., offers two types of physical exams for students: the basic physical and...
Cambridge Physicians Sports Medicine, Inc., offers two types of physical exams for students: the basic physical and the extended physical The charge for the basic physical is $105, while the charge for the extended physical is $135. Cambridge Physicians expects to perform 215 basic physicals and 185 extended physicals in July, 240 basic and 205 extended in August, and 85 basic and 65 extended in September. Prepare the sales budget for the service revenue expected from the physical exams performed...
to and 185 and 85 basic and 60 in Prepare the sales budget for the service revenue expected from the physical exams performed for the second quarter (July through September), with a column Extreme Sports Medicine, Inc July August September Quarter Number of exams performed (basic) Multiply by: Price per exam Sales revenue (basic) Number of exams performed (extended) Multiply by. Price per exam Sales revenue (extended) Total sales revenue Extreme Sports Medicine, Inc., offers two types of physical exams...
Managerial Accounting Benliver, Inc. manufactures and distributes a number or products to retailers. One of these products, Super Jetdry, requires two pounds of material R2D8 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter - July, August, and September. Peak sales of Super Jetdry occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: a. b. The finished goods...
Answer in excel Problems: 1. Benliver, Inc. manufactures and distributes a number or products to retailers. One of these products. Super Jetdry, requires two pounds of material R2D8 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter - July August, and September. Peak sales of Super Jetdry occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: a. The...
Water Sport Inc. manufactures a small personal water tube used for children learning to swim. Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist: a. The Marketing Department has estimated sales as follows for the remainder of the year (number of water tubes): July August September 7,400 October 5,900 November 4,900 December 3,800 3,400 2,900 The selling price of the water tubes is $60. b. All sales are...
Question Two (40 Marks): School Days Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units which are sold to public school systems throughout the mid-west. The controller of the company's Desk Division is currently preparing a budget for the third quarter of the year. The following sales forecast has been made by the division's sales manager. July 10,000 desk-and-chair sets August 12,000 desk-and-chair sets September 15,000 desk-and-chair sets Each desk-and-chair set requires 10 board feet of pine...
please make sure the answer is correct 100% Question Two (40 Marks): School Days Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units which are sold to public school systems throughout the mid-west. The controller of the company's Desk Division is currently preparing a budget for the third quarter of the year. The following sales forecast has been made by the division's sales manager. July 10,000 desk-and-chair sets August 12,000 desk-and-chair sets September 15,000 desk-and-chair sets Each...
Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do = = ). General Calibri B I 11 . Font - A A . .A. Wrap Text Merge & Center. U $ . % * 3 Alignment Number Clipboard R14 4. A . B C D G H nter the last 4 digits of your student ID number 4 Name/s: 7 Save this file in EXCEL FORMAT as: P2 Lastname 8 Round all...
help me with the requirement 7and 8 and also check if everything is correct and also make sure requirement 5 is correct where I entered 1500 in the yellow box please go through to every pic and make sure everything is correct 40 points Accounting 202 - Fall 2019 Project 3 - Operating Budget Enter the last 4 digits of your student ID number: Name/s: Highest Lowest other than 0 Save this file in EXCEL FORMAT as: P3Lastname Round all...
(2) Schedules Complete the sales and merchandise purchase plans with supporting schedules: a) A sales plan by month and in total, including a schedule of projected cash collections from sales and accounts receivable, by month and in total (2 schedules). b) An inventory purchases plan in units and in dollars, including a schedule of projected cash payments for purchases, by month and in total (3 schedules). NOTE: All schedules and budgets should be calculated based on information entered into the...