Premiere Products Exercises

6. Analyze results - Graph the data from Table 4 and describe what your graph looks like (you do not have to submit a picture of the actual graph!).

New Contribution Margin = New Price per unit – Variable cost per unit =$8.5-$2.5 =$6

Note: You can assume that variable costs are constant so that the average of them is the variable cost relevant for a change in sales.

Elimination of sales commision would affect the break-even volume to decrease, since the selling staff would have a lower incentive to sell due to having a cut of their commision salary. Eventually, this process would see a decrease in profit, since there would be no longer same selling jewellery incentive as before when the staff was paid in commissions. Therefore we strongly recommend to management to maintain selling commissions to to allow for an increased motivation, which would see an increased in the profit.

For example to delete a property if we delete the property in PROPERTY table and we can keep the owner data and to add data, for example, if add a owner data in OWNER table we don’t have to add property for that owner.

What we need to do is walk you through the steps to be able to freeze, or lock rows and columns, which will allow you to keep track of your placement when you scroll through your dataset. To do this we need to use the Freeze Pane option provided with your

We took the approach of ensuring a new database is created each time. If the database assignment6 is already existing, we will drop it and create a new one. This has both pros and cons. The pro is that we always know what we have, but if the database is large, this could take a bit of processing. Since in our case, the data base is relatively small, we can afford to do that each time. Since we're creating the databases each time, we do not need to drop any tables within in as given in the sample of assignment 6 description.

| On the Summary worksheet, in cell B8, construct a linking formula that will refer to the value in cell E25 on the Franklin Ave. worksheet. In cell C8, construct a linking formula that will refer to the value in cell E25 on the Main St. worksheet. On the Main St. worksheet, change the value in cell E6 to 45581.09. Note that the Quarter 4 sales total for the Main St. store updates automatically in the Summary sheet.

We had to send to the suppliers the files of the quantities and the details for the work we want from them to do it through website “wetransfer.com” because the size of file is so big and we can’t send it through h email.

-> SELECT ORDERS.ORDER_NUM, SUM(NUM_ORDERED * QUOTED_PRICE) AS TOTAL_AMOUNT FROM ORDERS, ORDER_LINE WHERE ORDERS.ORDER_NUM = ORDER_LINE.ORDER_NUM GROUP BY ORDERS.ORDER_NUM

Total Sales Dollars (for covering each incremental dollar of advertising) = Absolute increase in dollar sales / Advertising expense = $500,000 / $150,000 = $3.33

It would be best to use a diagram to compare the figures quickly and easily. I would order the information in lists with the most sales at the top and the least at the bottom.

Next we find the amount contributed from each Customer to the overall general and selling expenses based on the number of cartons ordered by each. The end result leads us to each customers overall profitability.

Parts Emporium Inc. managed to transform itself from doing business out of a garage to becoming the largest independent distributor of auto parts in the north central region. In the past period, inventory capacity rose from 65% to 90% and sales growth has stagnated causing Parts Emporium to hire an outside manager to figure out where the problem lies.

(Refer to original data.) Fuel cost is a significant variable cost to any railway. If crude oil increases by $ 20 per barrel, it is estimated that variable cost per passenger will rise to $ 90. What will be the new break-even point in passengers and in number of passenger train cars? Then, proceed to compute number of passengers =?