Question

In: Accounting

Prompt: Using the following assumptions, create the project budget. Note that this is a two -...

Prompt:

Using the following assumptions, create the project budget.

Note that this is a two - year budget, so you will need to show both years. Also, calculate the initial ROI for this project.

You do not have to consider the time value of money In this problem.

§

Assume that Blazer reevaluates the sales potential of this project, and

realizes that it will likely only sell half as many new units per year

than it initially expected when it first started thinking about this

project.

Would you recommend that Blazer proceed with the project or

not?

Explain your answer.

o

Requirements:

Present the budget in a table or spreadsheet. Show enough detail so that it is clear how your numbers were derived. Write your answer to the last question in sentences with a full explanation.

Blazer Corporation is considering a training project for its employees. This will be a two - year project with expected

cost savings each year. Calculate the break-even point of sales units in year 1 and year 2.

The project will involve purchasing new tablet devices for customer

service personnel. Of course, the personnel receiving the tables will need to learn how to use the new software. The staff will also be taught new customer service skills and sales skills in an effort to upsell the customers and create more sales income in the future.

1.

There are 22 customer service representatives on staff.

2.

The tablets will cost $475 per device. The tablets will last for 2 years or more. Annual insurance on the devices will be $25 per device. There will be no price increase in

the insurance for Year 2.

3.

The new customer service software subscription will cost $55.00 per year

per device. There will be no price increase in Year 2.

4.

The initial training cost on the new software will be $2,750 for all 22 of

the customer service representatives. In Year 2, there will be a refresher

course for new representatives, and that course will cost $100 per

participant. Blazer estimates that it will have a 50% turnover in its

customer service representatives for Year 2.

5.

The customer service skills seminar will have the following costs. Except

for the assessments, these costs will only be incurred in the first year.

a.

Seminar speaker: $2,000.00

b.

Books and materials: $975.00

c.

Lunch for participants: $15.00 per participant

d.

Assessment cost per participant: $50.00. Assessments will be

conducted on all customer service staff in Year 1 and all new staff

in Year 2.

6.

Blazer expects to sell an additional 2,750 of its product in Year 1 because

of this program. Blazer has a profit margin of $10 on each unit it sells.

22 Blazer expects to realize an additional 3,750 units of sales in Year 2 with

the same profit margin.

7.

Ignore the time value of money in this budget.

Expert Solution

Project involve purchase of Tablet device's for customer service personnel.

1. No.customer representative on staff= 22

2. Cost of tablet $475per device.

3. Total device = no.of customer representative.

4. Total tablet cost=$475×22=$10450

5. Initial training cost= $2750

6. Customer service skill cost=

(required to learn skill to operate, cost only in first year)

Seminar speaker=$2000

Books&material=$975

Lunch=$330, ($15×22)

total skill cost=$3305.

Therefore initial cost of investment=$10450+$2750+$3305=$16505.

Following is projected budget for two years.

Particulars	Year1	Year 2
Insurance ($25×22)	$550	$550
Software subscription ($55×22)	$1210	$1210
Assessment cost ($50×22)	$1100	$1100
Refreshment course training in year 2 only (22×$100)		$2200
Total cost	$2860	$5060
Units
2750 but only half likely to sell in year 1 3750 but only half likely to sell in year 2	1375	1875
Profit margin$10 per unit	13750	18750
Gross Sales revenue on sale of units $2860+$13750=16610 $5060+$18750= 23810	$16610	$23810

Calculation of initial ROI = Net return÷ cost of investment

Net income= $13750+$18750=$32500.

Cost of investment= $16505+$2860+$5060=$24425

Net return=32500-16505=$15995

ROI= ($15995÷24425)×100= 65.49%.

(2)

Break even point

Year 1

Fixed cost÷ profit per unit

Fixed cost = consider all cost incurred in first year

BEP= ($2860+$16505)÷$10 pet unit= 1937 units

However sale in 1st year 1375 units only.

Year 2

BEP= $5060÷$10 per unit= 506 units

However sale in year 2 is 1875 units.

In first year it not able to sell units to cover cost but in year 2 there is sufficient profit to cover both year cost.

ROI of project is 65.49% therefore Blazer should proceed with project.

ekkarill92 answered 2 years ago

Create a new project in BlueJ. Create two new classes in the project, with the following...

Create a new project in BlueJ. Create two new classes in the project, with the following specifications: Class name: Part Fields: id (int) description (String) price (double) onSale (boolean) 1 Constructor: takes parameters partId, partDescrip, and partPrice to initialize fields id, description, and price; sets onSale field to false. Methods: Write get-methods (getters) for all four fields. The getters should be named getId, getDescription, getPrice, and isOnSale.

using the data below create a time-phased budget for the project. Show how much daily and...

using the data below create a time-phased budget for the project. Show how much daily and cumulative costs of a project is, just as monthly and cumulative costs are shown in figure 10. WBS Activity Intermediate Predecessor Duration in Weeks Resource Hourly cost Hours per week 1 Operational definition 1.1 Research literature 3 Becky $35 30 1.2 Identify and define terms 1.1 1 Ann $60 30 1.3 Obtain approval of definition 1.2 2 Clive $50 30 2 Target selection 2.1...

5) Create the following in a Java program Create a scanner Prompt the user to enter...

5) Create the following in a Java program Create a scanner Prompt the user to enter the name where the box of mail is shipping from and create the variable and relate to scanner Prompt the user to enter the name of destination where the box of mail will be shipped and create the variable and relate to scanner Prompt the user to enter the weight of the package and create variable to relate to scanner Calculate cost of shipping...

Create a program using python that provides a simple calculator: Requires a login with a prompt...

Create a program using python that provides a simple calculator: Requires a login with a prompt for a username and a password prior to using the calculator If username and password are incorrect, the program should re-prompt to re-enter correct username and password Once logged in, the user should have access to the calculator and should have the ability for the following mathematical operators: Addition Subtraction Multiplication Division Square Root PI Exponents

2. Create a new project named named lab5_2. You will prompt the user for an amount...

2. Create a new project named named lab5_2. You will prompt the user for an amount of names to enter, and then ask for that amount of names. You’ll store these names in a vector of strings. Then you’ll sort the vector. Finally, you’ll print the results. How many names?: 4 Enter a name: Leonardo Enter a name: Donatello Enter a name: Michelangelo Enter a name: Raphael ==================== Alphabetized ==================== Donatello Leonardo Michelangelo Raphael

Create an amortization schedules using the following assumptions: Loan Term - 30 Year ARM Purchase Price...

Create an amortization schedules using the following assumptions: Loan Term - 30 Year ARM Purchase Price $120,000 Down Payment 6% Loan Amount 112,800 Interest Rate 11% 15% 13% Balance @ beginning of the year Year 15 Year 16 Year 25 Please show all the formulas you use so I can understand. 360 months = 30 years Please use this set up Month Beginning Loan Balance PMT Interest. Amortization Ending Cash Balance

6) Create the following in a Java Program: Create payroll system Prompt the user to enter...

6) Create the following in a Java Program: Create payroll system Prompt the user to enter payroll information Employee name and create variable for scanner Hours worked Hourly pay rate Federal tax rate State tax rate Declare variable doubles for gross pay, federal, state and total deduction Display payroll statement example: Name of employee Hours worked Hourly pay rate Gross pay which is equal hours worked multiply hourly pay rate Federal withholding which is equal of gross pay multiply federal...

In BlueJ, create a project called Lab6 Create a class called LineSegment –Note: test changes as...

In BlueJ, create a project called Lab6 Create a class called LineSegment –Note: test changes as you go Copy the code for LineSegment given below into the class. Take a few minutes to understand what the class does. Besides the mutators and accessors, it has a method called print, that prints the end points of the line segment in the form: (x, y) to (x, y) You will have to write two methods in the LineSegment class. There is information...

Create a Visual Studio console project named exercise101. The main() function should prompt for the name...

Create a Visual Studio console project named exercise101. The main() function should prompt for the name of a text file located in the same directory as exercise101.cpp, and search for a word in the text file as follows: Enter text file name: Enter search word: The program should print the number of occurrences of the word in the file: occurrences of were found in If the file could not be opened then display: File not found Use Stream file I/O...

Create a Linear Program solver using Matlab or Python. Prompt variable and constraint entry.