If I have a budget for $200,000.00 and we assume a $0.50 per transaction fee. If we limit the number of yearly transactions per user, can we meet this goal? If so, what does that limit need to be? (Please do on excel sheet with formulas to provide multiple options for this)
Transaction Fee | Budget | Yearly Transaction | Per User- No of transaction | No of persons available |
$ 0.50 | $ 200,000 | $ 400,000 | 5,000.00 | $ 80.00 |
$ 0.50 | $ 200,000 | $ 400,000 | 10,000.00 | $ 40.00 |
$ 0.50 | $ 200,000 | $ 400,000 | 20,000.00 | $ 20.00 |
$ 0.50 | $ 200,000 | $ 400,000 | 30,000.00 | $ 13.33 |
$ 0.50 | $ 200,000 | $ 400,000 | 40,000.00 | $ 10.00 |
$ 0.50 | $ 200,000 | $ 400,000 | 50,000.00 | $ 8.00 |
$ 0.50 | $ 200,000 | $ 400,000 | 60,000.00 | $ 6.67 |
$ 0.50 | $ 200,000 | $ 400,000 | 70,000.00 | $ 5.71 |
$ 0.50 | $ 200,000 | $ 400,000 | 80,000.00 | $ 5.00 |
$ 0.50 | $ 200,000 | $ 400,000 | 90,000.00 | $ 4.44 |
$ 0.50 | $ 200,000 | $ 400,000 | 100,000.00 | $ 4.00 |
$ 0.50 | $ 200,000 | $ 400,000 | 110,000.00 | $ 3.64 |
$ 0.50 | $ 200,000 | $ 400,000 | 120,000.00 | $ 3.33 |
$ 0.50 | $ 200,000 | $ 400,000 | 130,000.00 | $ 3.08 |
$ 0.50 | $ 200,000 | $ 400,000 | 140,000.00 | $ 2.86 |
$ 0.50 | $ 200,000 | $ 400,000 | 150,000.00 | $ 2.67 |
$ 0.50 | $ 200,000 | $ 400,000 | 160,000.00 | $ 2.50 |
$ 0.50 | $ 200,000 | $ 400,000 | 170,000.00 | $ 2.35 |
$ 0.50 | $ 200,000 | $ 400,000 | 180,000.00 | $ 2.22 |
$ 0.50 | $ 200,000 | $ 400,000 | 190,000.00 | $ 2.11 |
$ 0.50 | $ 200,000 | $ 400,000 | 200,000.00 | $ 2.00 |
$ 0.50 | $ 200,000 | $ 400,000 | 210,000.00 | $ 1.90 |
$ 0.50 | $ 200,000 | $ 400,000 | 220,000.00 | $ 1.82 |
$ 0.50 | $ 200,000 | $ 400,000 | 230,000.00 | $ 1.74 |
$ 0.50 | $ 200,000 | $ 400,000 | 240,000.00 | $ 1.67 |
$ 0.50 | $ 200,000 | $ 400,000 | 250,000.00 | $ 1.60 |
$ 0.50 | $ 200,000 | $ 400,000 | 260,000.00 | $ 1.54 |
$ 0.50 | $ 200,000 | $ 400,000 | 270,000.00 | $ 1.48 |
$ 0.50 | $ 200,000 | $ 400,000 | 280,000.00 | $ 1.43 |
$ 0.50 | $ 200,000 | $ 400,000 | 290,000.00 | $ 1.38 |
$ 0.50 | $ 200,000 | $ 400,000 | 300,000.00 | $ 1.33 |
$ 0.50 | $ 200,000 | $ 400,000 | 310,000.00 | $ 1.29 |
$ 0.50 | $ 200,000 | $ 400,000 | 320,000.00 | $ 1.25 |
$ 0.50 | $ 200,000 | $ 400,000 | 330,000.00 | $ 1.21 |
$ 0.50 | $ 200,000 | $ 400,000 | 340,000.00 | $ 1.18 |
$ 0.50 | $ 200,000 | $ 400,000 | 350,000.00 | $ 1.14 |
$ 0.50 | $ 200,000 | $ 400,000 | 360,000.00 | $ 1.11 |
$ 0.50 | $ 200,000 | $ 400,000 | 370,000.00 | $ 1.08 |
$ 0.50 | $ 200,000 | $ 400,000 | 380,000.00 | $ 1.05 |
$ 0.50 | $ 200,000 | $ 400,000 | 390,000.00 | $ 1.03 |
$ 0.50 | $ 200,000 | $ 400,000 | 400,000.00 | $ 1.00 |
If I have a budget for $200,000.00 and we assume a $0.50 per transaction fee. If...
PLEASE HELP! The master budget must be completed using formulas. there must be a sales budget, production budget, Direct Materials budget, Direct labor budget, manufacturing overhead budget, selling and admin budget, budgeted income statement, Schedule of exp collections, sch of exp payments, sch of exp payments DM, cash budget, and budgeted balance sheet. please include the formulas you used. Purpose: The purpose of this project is to help you practice and reinforce the steps necessary to complete a Master Budget,...
Quarter 11,200 kayaksQuarter 21,500 kayaksQuarter 3750 kayaksQuarter 4700 kayaksKK’s policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarter's anticipated sales. Preliminary sales projections for 2022 are 1,100 units for the first quarter and 1,500 units for the second quarter. Ending inventory of finished goods at December 31, 2020, will be 200 kayaks. Production of each kayak requires 54 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). Company policy...
I have a hard time doing budgets using excel. can someone help me out with questions on this? I did not do well when I submitted it so I am not sure what I did wrong. We were unable to transcribe this image2019SummerFinal Project due 310 - Excel katie, [email protected] - AutoSave a File Home A1 0 X Comments Insert Page Layout Formulas Data Review View Help Search Share x 4 Part 1 M N O 45 Advertising $900 per...
C++ -- Event processing simulation using a transaction queue Hi! it is queue simulation please read the instructions, write codes, and explain the code with comments. Thank you Transactions enter the system and are stored in a queue. Each transaction represents some work that needs to be accomplished. Servers exist which process transactions. Servers take transactions off the queue and process them. you’re building the simulation framework. The idea is that somebody would take your framework, and add the specifics...
ACCT 116 Budget Assignment Kline Sisters Company operates a gift shop where peak sales and activity occur in the months of December and January. Data regarding the store's operations follow: Sales are budgeted at $360,000 for January, 320,000 for February, and $250,000 for March and $240,000 in April. Collections are expected to be 30% in the month of sale, 65% in the month following the sale, 3% in the second month following sale and 2% uncollectible. The cost of goods...
i need help with this exce problem. i got everyrhing done but im stuck on G and im noy sure what to do. please if answer do it in excel. than k you Sue has opened a bakery specializing in Gun Oakery specializing in cupcakes. Herhude must account for fixed expenses, such as her facility lease, utilities, and credit card equipment fees. In addition, she acca costs including cost of goods sold and credit card processing fees. You will use...
Part 2: Cost Benefit Analysis Assumptions In order to simplify the cost benefit analysis, we will not make a net present value calculation for each cost and income. Please report all calculations in yearly terms Please calculate the cost benefit over a 5 year term Instructions Please create a table that lays out the project cost and benefits (15) Please create a table that shows the cost over 5 years (5) Please create a table that shows the benefit over...
Project: Assume that you are 18 years old and you would like to have $10000001000000 in your account by the time you are 6060 years old. A list of various savings accounts was compiled in your Excel file. Calculate the required initial (present value) deposit to the savings accounts based on the interest rates in column C compounded based on the values in column D. Choose the savings account id (column A) that requires the minimum initial investment. When you...
2-6% each part Suppose we have opened a catfish hot dog stand at the mall which will be open 4 hours per day. We are test marketing our sales at various prices to attempt to determine the best price we should use for our catfish hot dogs. So, let: Price of the Number of y hot dogs $1.50 $3.00 $4.00 hot dogs sold 182 118 39 Notice that we have put these variables in the same order that we did...
I need this answered in Microsoft Excel please GBCoffee Budget Project The GBCoffee Company roasts and sells high quality certified sustainable coffee beans. The final one pound bags of roasted whole coffee beans has two direct materials – coffee beans and packaging. GBCoffee is preparing budgets for the fourth quarter ending December 31, 2019. For each requirement below prepare budgets by month for October, November, and December, and a total budget for the quarter. 1. The previous year’s sales for...