Question

IniVEND has been in business for a year now and seem to be doing quite well. As they explore opportunities for growth, they want to figure out what their future financial position is going to look like as well as analyze pportunities to diversify their product and machine offering. UniVEND will upgrade its machines according to their customers needs. All values are provided in Turkish Liras (TL). Part 1 Answers What is the total rent cost of all the machines used by UniVEND each month? Report the total monthly fixed cost basis. How many products have to be sold each month to cover the monthly fixed cost basis? Prepare an annual Pro Forma Income Statement of UniVEND based on the information provided b) Revenue: Cost of Goods Sold: Gross Margin: S&A Expenses Income before Taxes Income Tax Expense Net Income b) d) Some customers have been complaning about finding coins for the machine. Thus, UniVEND decided to upgrade their machines to pay with a zip, a plastic key that acts like a debit card. Customers can still pay with coins. UniVEND willl onl Part 2 y upgrade Vendo Cold Drink machines UniVEND provides small amount of discount for the zip to encourage adoption. The company also sell the zip with the price of 15 TL. The upgrade cost for each machine is 250 TL and material cost per zip is 1 TL What is the total upgrade cost for all Vendo Cold Drink machines? Consider a customer of Univ END monthly spends 35 TL in Vendo Cold Drink machines. The zip provides to customers 8% discount for any product in that type of machines. How many months later, customer will cover the cost that he/she paid for zip? Do not round the number to the nearest integer.) After upgrading Vendo Cold Drink machines and the promotion ofzip the average sales number monthly or every upgraded machine has increased by 11%. Also the discount or every product in these machines is 8%. Report the new numbers. (Hint: Do not forget to add upgrade cost!) b) Cost of Goods Sold: Net Income 13 Average Earning Turkish Corporate Tax Rate 20.0% verage price 2.00 TL per product Variable Costs Average Cost Average Sales Number 1.65 TL per product per product average sales (monthly) 7,500.00 per machine average cost variable overhead 0.05 TL Fixed Costs Vending Machines Necta Snaccky Max Necta Snaccky Elektral Midi Bufe Elektral Maxi Bufe Vendo Cold Drink Number of Machines Vending Machines Rent Necta Snaccky Max Necta Snaccky Elektral Midi Bufe Elektral Maxi Bufe Vendo Cold Drink 250.00 TL 250.00 TL 350.00 TL 650.00 TL 450.00 TL 200.00 TL 4,000.00 TL monthly -per machine monthly -per machine monthly -per machine monthly - per machine monthly - per machine per machine for all machines 13 Utilities (monthly) Fixed Overhead(monthly) Selling & Admin Costs 3,300.00 TL 18,000.00 TL monthly annually Selling and Administration

Please can you solve by showing the formulas

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1. (a) answer = 11,550 TL

no of machines total monthly rent (per machine rent * total machines) Necta Snaccky Max rent (monthly) Necta Snaccky Max rent

(b) Fixed cost monthly basis = Total monthly Fixed Cost / total number of machines

21,350 TL / 29 machines = 736.206 TL per machine

Fixed cost Necta Snaccky Max rent (monthly) Necta Snaccky Max rent (monthly) Elektral Midi Bufe rent (monthly) Elektral Maxi Bufe rent (monthly) Vendo Cold Drink rent (monthly) per machir no of machines total monthly rent (per machine renttotal mad 250 250 350 650 450 1250 750 1750 1950 5850 13 utilities ( monthly) fixed overhead (monthly- all machines) 200 29 5800 4000 21350

(c) monthly cost basis is rounded off to 736.206 TL , per product price is 2 TL , so total number of products to be sold per month to cover the cost basis would be 736.206 TL / 2 TL = 367 products

Question 2

per product per machine total annual products (per machine) total products( for 29 machines) price 435000 7500 217500 Variable cost average cst total variable cost (VC) 1.65 0.05 12375 375 12750 Necta Snaccky Max machines Necta Snaccky Max machines Elektral Midi Bufe machines Elektral Maxi Bufe machines Vendo Cold Drink machines 3 Fixed Cost Necta Snaccky Max rent (monthly) Necta Snaccky Max rent (monthly) Elektral Midi Bufe rent (monthly) Elektral Maxi Bufe rent (monthly) Vendo Cold Drink rent (monthly) per machine 250 250 350 650 450 monthly fixed cc annual cost 1250 750 1750 1950 5850 15000 9000 21000 23400 70200 13 revenue less COGS (VC+FC) gross margin less S&A income before tax tax expense (20%) net income 435000 268950 166050 57600 108450 -21690 86760 utilities(monthly) Fixed overhead (monthly- all machines) total fixed cost (FC) 200 5800 69600 48000 256200 4,000 S&A Management salaries (monthly) S&A (annualy) total S&A 3,300 18,000 39600 18,000 57600

question 3

(a) the total upgrade cost of the vending drink machine would be 250TL per machines and for a total of 13 machines, the total upgrade cost would be 3250 TL. The material cost of zip will not be included since it is a variable cost and the quantity of the zips will be depended on the customer demand and the companies choice in how many zips they would like to make prior.

(b) On the the 35 TL spent every month, the 8% discount would amount to 2.8 TL. So for the zip cost of 15 TL, the customer would recover the zip costs in 5.357 months ( zip cost/ discount every month= 15/ 2.8)

question 4

( will need more information relating this questions, including number of zip solds not just increased in sales, since each customer can buy multiple products but will just use one zip)

Add a comment
Know the answer?
Add Answer to:
Please can you solve by showing the formulas IniVEND has been in business for a year...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Some customers have been complaning about finding coins for the machine. Thus, UniVEND decided to upgrade...

    Some customers have been complaning about finding coins for the machine. Thus, UniVEND decided to upgrade their machines to pay with a zip, a plastic key that acts like a debit card. Customers ca still pay with coins. UniVEND will only upgrade UniVEND provides small amount of discount for the zip to encourage adoption. The company also sell the zip with the price of 15 TL The upgrade cost for each machine is 250 TL and material cost per zip...

  • Prepare an annual Pro Forma Income Statement of UniVEND based on the information provided Revenue: Cost...

    Prepare an annual Pro Forma Income Statement of UniVEND based on the information provided Revenue: Cost of Goods Sold Gross Margin S&A Expenses: Income before Taxes: Income Tax Expense: Net Income b) d) Price Average Earning Turkish Corporate Tax Rate 20.0% average price 2.00 TL per product Variable Costs Average Cost Average Sales Number 1.65 TL 0.05 TL per product per product average sales (monthly) 7,500.00 per machine average cost variable overhead Fixed Costs Vending Machines Necta Snaccky Max Necta...

  • What is the total rent cost of all the machines used by UniVEND each month? Report...

    What is the total rent cost of all the machines used by UniVEND each month? Report the total monthly fixed cost basis. How many products have to be sold each month to cover the monthly fixed cost basis? b) Price Average Earning Turkish Corporate Tax Rate 20.0% average price 2.00 T per product Variable Costs Average Cost Average Sales Number 1.65 TL 0.05 TL per product per product averoge soles (monthly) 7,500.00 per machine average cost variable overnead Fixed Costs...

  • Can you show the solution on the excel by showing the formulas? Tender Announcement of Vending...

    Can you show the solution on the excel by showing the formulas? Tender Announcement of Vending Machines at MetroBus Stops Istanbul Metropolitan Municipality (IMM) decided to rent out spots at MetroBus stops for vending machines to meet traveler demands and increase revenue. To ensure transparency and equal treatment, a tender was published on IMM's website. UniVEND saw this opportunity and gave the proposal to IMM. UniVEND's proposal was accepted and the company started to operate in all metrobus stops. Now...

  • Suppose you have decided to start a small business selling snacks from vending machines. You have...

    Suppose you have decided to start a small business selling snacks from vending machines. You have secured a location for one candy vending machine in a local bookstore. Rental for the space will cost $200 per month. Vending machines can be purchased at wholesale clubs such as Sam’s Club and Costco. You can also purchase the snacks to stock the machines in bulk there. 1. Either visit a local warehouse club or review its website to determine the initial cost...

  • Suppose you have decided to start a small business selling snacks from vending machines. You have...

    Suppose you have decided to start a small business selling snacks from vending machines. You have secured a location for one candy vending machine in a local bookstore. Rental for the space will cost $200 per month. Vending machines can be purchased at wholesale clubs such as Sam’s Club and Costco. You can also purchase the snacks to stock the machines in bulk there. REQUIRED: Assume your machine can accommodate more than one product, for example, a snack machine that...

  • Suppose you have decided to start a small business selling snacks from vending machines. You have...

    Suppose you have decided to start a small business selling snacks from vending machines. You have secured a location for one candy vending machine in a local bookstore. Rental for the space will cost $200 per month. Vending machines can be purchased at wholesale clubs such as Sam’s Club and Costco. You can also purchase the snacks to stock the machines in bulk there. REQUIRED: Assume your machine can accommodate more than one product, for example, a snack machine that...

  • Suppose you have decided to start a small business selling snacks from vending machines. You have...

    Suppose you have decided to start a small business selling snacks from vending machines. You have secured a location for one candy vending machine in a local bookstore. Rental for the space will cost $200 per month. Vending machines can be purchased at wholesale clubs such as Sam’s Club and Costco. You can also purchase the snacks to stock the machines in bulk there. 1. Either visit a local warehouse club or review its website to determine the initial cost...

  • if you can please answer A,B&C i will glady give a thumbs up thank you. Holton...

    if you can please answer A,B&C i will glady give a thumbs up thank you. Holton Company makes three products in a single facility. Data concerning these products follow. Product А Selling price per unit Direct materials Direct labor Variable manufacturing overhead Variable selling cost per unit Mixing minutes per unit Monthly demand in units $91.10 $79.30 $89.40 $39.60 $44.20 $53.70 $28.60 $14.20 $11.30 $ 5.50 $ 4.89 $ 5.30 $5.00 $ 3.50 $ 3.20 8.90 2.50 2.50 3,000 1,800...

  • NewYork Auto has been in the tire business for four years. It rents a building and...

    NewYork Auto has been in the tire business for four years. It rents a building and owns all of its equipment. All employees are paid a fixed salary except for the busy season (April-June), when temporary help is hired by the hour. Utilities and other operating charges remain fairly constant during each month except those in the busy season. Selling prices per tire average $75 except during the busy season.Because a large number of customers buy tires prior to winter,...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT