solution

/in /by

Connelly Incorporated, a manufacturer of quality electric ice cream makers, has experienced a steady growth in sales over the past few years. Because her business has grown, Jan DeJaney, the president, believes she needs an aggressive advertising campaign next year to maintain the company’s growth. To prepare for the growth, the accountant prepared the following data for the current year:

Variable costs per ice cream maker
Direct labor $ 15.00
Direct materials 18.50
Variable overhead 7.50
Total variable costs $ 41.00
Fixed costs
Manufacturing $ 95,500
Selling 55,500
Administrative 548,000
Total fixed costs $ 699,000
Selling price per unit $ 75
Expected sales (units) 41,000

.If the costs and sales price remain the same, what is the projected operating profit for the coming year?

2. What is the breakeven point in units for the coming year?

3. Jan has set the sales target for 45,400 ice cream makers, which she thinks she can achieve by an additional fixed selling expense of $234,165 for advertising. All other costs remain as per the data in the above table. What will be the operating profit if the additional $234,165 is spent on advertising and sales rise to 45,400 units?

4-a. What will be the new breakeven point if the additional $234,165 is spent on advertising?

4-b. Prepare a contribution income statement at the new breakeven point.

4-c. What is the percentage change in both fixed costs and in the breakeven point?

5. If the additional $234,165 is spent for advertising in the next year, what is the sales level (in units) needed to equal the current year’s operating profit at 41,000 units?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

/in /by

The Jurassic Classics has four employees on its sales team and uses a compensation that provides each person with a base salary of $48,000 per year and the opportunity to earn commission on sales. The current commission is 5% of gross sales, and sales for the most recent period were $3,000,000. Management is considering making a change to the compensation system and wants to evaluate two possible alternatives: going to a strictly commission-based compensation system and going to purely salary-based compensation. The strictly commission-based method would eliminate the salary but raise the commission to 11% of sales. If the purely salary-based approach is adopted, the salary for each person would rise to $84,000 and the commission would be eliminated.

Required:

1. Compute the total compensation of the sales team for all three options at $2,400,000, $3,000,000, and $3,400,000 of total sales.
Sales Current Method Commission Only Salary Only
$2,400,000
$3,000,000
$3,400,000

2. What sales level would make management indifferent between the current compensation structure and the strictly commission-based structure? What is the point of indifference between the current structure and the pure salary-based structure? (Round your answer to the nearest whole dollar.)
Point of Indifference
Current versus commission only
Current versus salary only
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

/in /by

Exp19_Access_Ch04_HOEAssessment – Leadership Conference 1.1

Project Description:

You will create a form so that users of the database can enter and edit registrations to the conference easily. You create an attractive report that groups the conference sessions by speaker, and then export it to PDF format for easy distribution. Finally, you create a Navigation Form so that database users can switch between major objects in the database readily.

Steps to Perform:

Step

Instructions

Points Possible

1

Start Access. Open the downloaded Access file named Exp19_Access_Ch04_HOEAssessment_Conference.accdb. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.

0

2

You will create a form to manage the data in the Registration table. Use the Form tool to create the form and then modify the form as required. You will also remove the layout control from the form so that the controls can be repositioned freely.
Select the Registration table as the record source for a form. Use the Form tool to create a new form with a stacked layout.

12

3

Change the form’s title to Enter/Edit Registrants. Click the layout selector and with all of the fields and labels selected, set the width of the controls to about 3″.

5

4

Set the background color of the RegistrationID text box to Tan, Background 2, and set the font size to 14. Save the form as Edit Registrations.

5

5

Open the Edit Registrations form in Design view. Select all controls in the Detail section of the form, and then remove the layout. View the form in Layout view. Delete the City label from the form and move the text box up and to the right of Address so that their top edges are aligned.

5

6

Delete the State/Provence and Postal Code labels from the form and move the Postal Code text box up and to the right of State so that their top edges are aligned. Move the State/Provence and Postal Code text boxes up to below Address and City so that they close in the white space, keeping the spacing close to that of the controls above them.

9

7

View the form in Print Preview and set the orientation to Landscape. Switch to Form view, and then save and close the form.

0

8

You will create a report based on the Speaker and Room Schedule query. You decide to use the Report Wizard to accomplish this task. You are planning to email a copy of the report to your speakers, who are not all familiar with Access, so you will export the report as a PDF file prior to sending it.
Select the Speaker and Room Schedule query in the Navigation Pane as the record source for a report. Activate the Report Wizard and use the following options as you proceed through the wizard steps:
Select all of the available fields for the report. View the data by Speakers. Accept the default grouping levels and click Next. Use Date as the primary sort field in ascending order.
Accept the Stepped and Portrait options. Save the report as Speakers by Name.

13

9

Switch to Layout view and apply the Retrospect theme to this report only. Switch to Report view to determine whether all the columns fit across the page. Switch back to Layout view.

7

10

Delete the Room ID label and text box from the report. Drag the right edge of the Session Title text box to the right so that the column width is wide enough to display the values in the field (approximately 3″). Save the report.

4

11

Switch to Print Preview and export the report as a PDF file named Speaker by Name. Close the reader program that displays the PDF report and return to Access. Close Print Preview. Close the report.

2

12

You realize that the StartingTime field was not included in the query that is the record source for your report. You add the field to the query and then modify the report in Layout view to include the missing field.
Open the Speaker and Room Schedule query in Design view. Add the StartingTime field from the Sessions table to the query design grid, after the Date field. Run, save, and close the query.

7

13

Open the Speakers by Name report in Layout view. Add the StartingTime field from the Field List pane by dragging it into the report layout. Click the selection handle at the top of the StartingTime column and move the column immediately to the right of the SessionTitle field. Switch to Print Preview, then save and close the report.

6

14

You will create a Navigation Form so that users can switch between objects in the database readily.
Create a Vertical Tabs, Left Navigation Form.

12

15

Drag the Edit Registrations form icon from the Navigation Pane onto the [Add New] tab at the left of the form.

3

16

Drag the Speakers by Name report icon from the Navigation Pane onto the second [Add New] tab at the left of the form. Save the Navigation form with the default name, Navigation Form. Close the form.

3

17

View the Room Information form and the data in Form view. Sort the records by Capacity in descending order. Save and close the form.

7

18

Close all database objects. Close the database and then exit Access. Submit the database as directed.

0
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

/in /by

Which type of scale provides participants with an opportunity to express no opinion when they are unable to make a choice among the alternatives offered?

Forced-choice

Multidimensional

Balanced

Unbalanced

Unforced-choice

2. Which type of scale is used when participants score an object according to its comparative order among two or more objects?

Ranking

Rating

Categorization

Sorting

Recording

3. In mail and in web-based surveys, which form of order bias is likely to occur?

Recency effect

Primacy effect

Halo effect

Demand effect

Leniency

4. When it is not possible to randomly assign participants to groups, _____ should be used.

control groups

matching

replication

purposive assignment

pilot testing

5. True experimental designs differ from pre-experimental designs in that _____.

true experimental designs use random assignment

pre-experimental designs include the use of a control group

pre-experimental designs include the use of pre-tests

true experimental designs include multiple treatment groups

pre-experimental designs have fewer threats to internal validity

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"