Purchase Solution

Formula to determine variable of gross profit %

Not what you're looking for?

Ask Custom Question

Attached is a spreadsheet with two accounts. Each account has the same retail and invoice. One school has a small enrollment and the other has a larger enrollments. There is a handling fee of $2 per enrollment. There are only two variables that can be changed: brochure cost & incentives. Also, the larger the enrollment, the larger the brochure cost. Brochure Cost can be reduced only a certain amount. The cheapest it can be reduced is 110% of # of students. So for John Spicer, the Brochure Cost could be reduced to 683.10 (621 students x 1.10 = $683.10)

The goal is to reach a 36% gross profit margin...which is (profit / invoice). Profit is Invoice - Total Expenses

There should be a way to figure a lump sum of the amount you have to spend on brochures and incentives. For example of Spicer, you can spend $843.10 on brochures and incentives....which is $683.10 on brochures and $160.00 on incentives.

I can figure adjust brochure cost & incentive cost to reach the 36% but I know there is a formula to make it easier.

Attachments
Purchase this Solution
Solution Summary

This solution is comprised of a detailed explanation to determine variable of gross profit %.

Solution Preview

Hello,
In order to solve this problem, let's first write the definitions of Total Expenses, Profit and Gross Profit %.

Total Expenses = Brochure Cost + Product Cost + Freight Cost + Prizes + Incentives +
+ Techer Gifts + Samples + PackOut + Delivery + Handling

Profit = Invoice - Total Expenses

Gross Profit % = Profit/Invoice

You are interested in finding the sum of Brochure Cost + Incentives such that the gross profit percentage is 36%. Since you mentioned that costs that are not brochures or incentives are "fixed" ...

Purchase this Solution
Free BrainMass Quizzes
Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Probability Quiz

Some questions on probability

View More Free Quizzes
Related BrainMass Solutions

  • Herrestad Company contribution margin (behavioral, variable)

    Prepare a second version assuming the selling price per unit increases to $280 per unit. Use the original information to: Determine the number of units the company must sell to break even for the year?

  • determine the amount of sales (units) for target profit

    370420 determine the amount of sales (units) for target profit Battonkill Company, operating at full capacity, sold 112,800 units at a price of $150 per unit during 2010.

  • Inventory, turnover ratio and gross profit ratio

    + 18,750)/2] = $175,000 / $17,012 = 10.29 Average days in inventory - This formula is used to determine how quickly a company is converting their inventory into sales using the following formula: 365 / Inventory turnover ratio = 365

  • Mathematics Formulas that Businesses Need

    If you know your fixed costs (FC), your variable costs per unit (VCu), your price per unit (P), and the number of units (U) sold, you can use a mathematical equation to determine your net income (NI).

  • Disney corporation: Ratio analysis

    GROSS PROFIT MARGIN: This is a ratio that measures the amount of profit, generated by the company, on its core operations. The gross profit represents the gain (loss) generated in pursuing its main trading activity.

  • Derive missing amounts in income statements

    Here's the formula for computation: Sales - CGS = Gross Profit - Operating expense = NI Sales Cost of Goods Sold Gross Profit Operating Expenses Net Income $75,000 $46,400 $28,600 $17,800 $10,800 $108,000

  • Break Even and Target Income

    Assuming that Newman decides to sell its product for $23 per unit, determine the number of units it must sell to generate a $100,000 profit B&B Company First, you must figure the cost of goods sold (COGS) to determine the amount of profit each unit

  • Gross Margin Comparison

    This solution is comprised of a detailed calculation, including all the requisite steps, to determine ROI of a company in the given business finance problem.

  • Cost-Volume-Profit Analysis and Operating Leverage

    It begins with the basic formula of PROFIT = Revenue - Costs. Taken a step further, it delineates costs into two categories, fixed and variable costs.

View More Related Solutions