Holding all assumptions constant except rebate claim rate

Assignment Help Financial Accounting

Reference no: EM131247559

Schalpfer Inc. is trying to determine whether to give a $15 rebate, to cut the price to $8, or to have no price change on a software networking product. Currently, 40,000 units of the product are sold each week for $45. The variable cost of the product is $6. The most likely case appears to be that a $15 rebate will increase sales 35% and about two-thirds of all people will claim the rebate. For this price cut, the most likely case is that sales will increase 25%.

A) Given all other assumptions, use Excel to create a model that describes all the scenarios given.

B) Holding all assumptions constant except the rebate claim rate, at what rebate clain rate would the rebate and price cut be equally desirable?

C) Is the no price change scenario a good choice? When?

PLEASE show formulas and excel screen shots if possible.

Reference no: EM131247559

Questions Cloud

Accounts debited and credited for each transaction : A chart of accounts is a: list of account titles with corresponding reference numbers used by companies so that transaction items are consistently named. summary of each account's activity and its ending balance. list of each account and its balance ..

Represent typical process manufacturing industries : The following categories represent typical process manufacturing industries: Beverages, Chemicals, Food, Metals, Pharmaceuticals, Cosmetics. Typical products manufactured by the selected company, including brand names. Typical raw materials used by t..

Manufacturing overhead costs incurred : Manufacturing overhead costs incurred: Property taxes, factory $ 3,000 Utilities, factory 5,000 Indirect labor 10,000 Depreciation, factory 24,000 Insurance, factory 6,000 Total actual manufacturing overhead costs $ 48,000 Other costs incurred: Prepa..

Prepare an unadjusted trial balance : If total liabilities decreased by $25,200 and stockholders' equity increased by $4,900 during a period of time, then total assets must change by what amount and direction during the same time period? At September 30, Balance Corporation reported the ..

Holding all assumptions constant except rebate claim rate : Schalpfer Inc. is trying to determine whether to give a $15 rebate, to cut the price to $8, or to have no price change on a software networking product. Currently, 40,000 units of the product are sold each week for $45. The variable cost of the produ..

Loan amortization and EAR-monthly loan payment : Loan amortization and EAR You want to buy a car, and a local bank will lend you $40,000. The loan will be fully amortized over 5 years (60 months), and the nominal interest rate will be 6% with interest paid monthly. What will be the monthly loan pay..

How much cash will be required to settle the liability : The margin of safety is: Amarillo Company experienced the following events during its first accounting period. (1) Purchased $5,000 of inventory on account under terms 1/10/n30. (2) Returned 1,000 of the inventory purchased in Event 1. If the Company..

Payable within discount period for the inventory purchased : Amarillo Company experienced the following events during its first accounting period. (1) Purchased $5,000 of inventory on account under terms 1/10/n30 (2) Returned 1,000 of the inventory purchased in Event 1. (3) Paid the remaining balance in accoun..

Sales taxes separately on the cash register : Oakley Company does not ring up sales taxes separately on the cash register. Total receipts for February amounted to $42,800. If the sales tax rate is 7%, what amount must be remitted to the state for February's sales taxes?

User Account

All Pages