Hey Everyone, In this video , i am going to provide you a quick walkthrough of Advanced Data entry web Form which has all functionalities like Searching records by any field Deleting Records Updating Record For Updating and Deleting records, it also enabled userid and passsword to integrate data authencity. Apart from that this form can also input data from mobile also which makes it quite user friendly. Here is the link of the form: script.google.com/macros/s/AK... If you like this form functionalities or even you required something different form with other functionalities, please reach me out over my email address: arunkumar9896@gmail.com or skype arunkumar9766@outlook.com Also I can help you in data analysis also using dashboards, charts and graphs
This video offers an in-depth overview of a Sales Dashboard Tracker, featuring diverse categories and dynamic graphs and slicers to furnish varied insights into sales data across categories. For inquiries regarding customizations or similar project requirements, please feel free to contact me via email at arunkumar9896@gmail.com. You can also view my work profile on Freelancer and Upwork: Freelancer: www.freelancer.com/u/arunkuma... Upwork: www.upwork.com/freelancers/~0... Additionally, you can reach me via WhatsApp/Telegram at +917357186374 or on Skype at arunkumar9766@outlook.com.
Hello Everyone, This video provides a walkthrough of Recruitment dashboard summary for hiring process in detailed wise . If you require any customisations or similar dashboard to be created. You can hire me on freelancer.com or upwork . Profile: www.freelancer.com/u/arunkumar9896 www.upwork.com/freelancers/~01bc460d43f949d464 Contact details(WhatsApp/ telegram):+917357186374 Skype id:arunkumar9766@outlook.com email:arunkumar9896@gmail.com
This video provides a walkthrough of Efficient Frontier Automated Excel Graph with 16 securities with automatic analysis using excel vba script. To get this file please email me on arunkumar9896@gmail.com whatsapp/telegram number:+917357186374
Hello. I'm from Uruguay. Is there any possibility of getting this program to apply it with children's soccer for children from 5 to 12 years old? Thank you
This video provides a quick walkthrough of Loan amortization scheduler and calculator in excel with financial details (cashflow and forecasting). My details: email: arunkumar9896@gmail.com WhatsApp/telegram: +917357186374 Freelancer profile:www.freelancer.com/u/arunkuma... Here are features of this template Features: Tax slabs Forecasting Monthly payments schedule Cashflows Outflow and Inflow Personal Assets Net Assets Super Assets Loan Calculator
Hey Arun I have seen your profile and excited to work with you on long term basis, please share your email address , i will share you the job description.Thanks
This video solves the linear question using excel solver and excel formulas. For excel file please contact me on email: arunkumar9896@gmail.com WhatsApp +917357186374 An introduction to management Science
Frandec Company manufactures, assembles, and rebuilds material handling equipment used in warehouses and distribution centers. One product, called a Liftmaster, is assembled from four components: a frame, a motor, two supports, and a metal strap. Frandec’s production schedule calls for 5000 Liftmasters to be made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing and purchase costs per unit are shown. Component Manufacturing Cost P urchase Cost Frame $38.00 $51.00 Support $11.50 $15.00 Strap $ 6.50 $ 7.50 Three departments are involved in the production of these components. The time (in minutes per unit) required to process each component in each department and the available capacity (in hours) for the three departments are as follows: Department Component Cutting Milling Shaping Frame 3.5 2.2 3.1 Support 1.3 1.7 2.6 Strap 0.8 - 1.7 Capacity (hours) 350 420 680 Formulate and solve a linear programming model for this make-or-buy application. How many of each component should be manufactured and how many should be purchased? b. What is the total cost of the manufacturing and purchasing plan? c. How many hours of production time are used in each department? d. How much should Frandec be willing to pay for an additional hour of time in the shaping department? e. Another manufacturer has offered to sell frames to Frandec for $45 each. Could Frandec improve its position by pursuing this opportunity? Why or why not? This video solves the linear question using excel solver and excel formulas. For excel file please contact me on email: arunkumar9896@gmail.com WhatsApp +917357186374 An introduction to management Science
This video solves the linear question using excel solver and excel formulas. For excel file please contact me on email: arunkumar9896@gmail.com WhatsApp +917357186374 An introduction to management Science
The Ferguson Paper Company produces rolls of paper for use in adding machines, desk calculators, and cash registers. The rolls, which are 200 feet long, are produced in widths of 11/2, 21/2, and 31/2 inches. The production process provides 200-foot rolls in 10-inch widths only. The firm must therefore cut the rolls to the desired final product sizes. The seven cutting alternatives and the amount of waste generated by each are as follows: Cutting Number of Rolls Waste Alternative 11/2 in. 21/2 in. 31/2 in. (inches) 1 6 0 0 1 2 0 4 0 0 3 2 0 2 0 4 0 1 2 1/2 5 1 3 0 1 6 1 2 1 0 7 4 0 1 1/2 The minimum requirements for the three products are Roll Width (inches) 11/2 21/2 31/2 Units 1000 2000 4000 a. If the company wants to minimize the number of 10-inch rolls that must be manufactured, how many 10-inch rolls will be processed on each cutting alternative? How many rolls are required, and what is the total waste (inches)? b. If the company wants to minimize the waste generated, how many 10-inch rolls will be processed on each cutting alternative? How many rolls are required, and what is the total waste (inches)? c. What are the differences in parts (a) and (b) to this problem? In this case, which objective do you prefer? Explain. What types of situations would make the other objective more desirable? This video solves the linear question using excel solver and excel formulas. For excel file please contact me on email: arunkumar9896@gmail.com WhatsApp +917357186374 An introduction to management Science
This video solves the linear question using excel solver and excel formulas. For excel file please contact me on email: arunkumar9896@gmail.com WhatsApp +917357186374 An introduction to management Science
This video solves the linear question using excel solver and excel formulas. For excel file please contact me on email: arunkumar9896@gmail.com WhatsApp +917357186374
Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the store’s leading products use the Romans Food Market name: Romans Regular Coffee and Romans DeCaf Coffee. These coffees are blends of Brazilian Natural and Colombian Mild coffee beans, which are purchased from a distributor located in New York City. Because Romans purchases large quantities, the coffee beans may be purchased on an as-needed basis for a price 10% higher than the market price the distributor pays for the beans. The current market price is $0.47 per pound for Brazilian Natural and $0.62 per pound for Colombian Mild. The compositions of each coffee blend are as follows: Bean R egular DeCaf Brazilian Natural 75% 40% Colombian Mild 25% 60% Romans sells the Regular blend for $3.60 per pound and the DeCaf blend for $4.40 per pound. Romans would like to place an order for the Brazilian and Colombian coffee beans that will enable the production of 1000 pounds of Romans Regular coffee and 500 pounds of Romans DeCaf coffee. The production cost is $0.80 per pound for the Regular blend. Because of the extra steps required to produce DeCaf, the production cost for the DeCaf blend is $1.05 per pound. Packaging costs for both products are $0.25 per pound. Formulate a linear programming model that can be used to determine the pounds of Brazilian Natural and Colombian Mild that will maximize the total contribution to profit. What is the optimal solution and what is the contribution to profit? This video solves the linear question using excel solver and excel formulas. For excel file please contact me on email: arunkumar9896@gmail.com WhatsApp +917357186374
This video solves the linear question using excel solver and excel formulas. For excel file please contact me on email: arunkumar9896@gmail.com WhatsApp +917357186374 An investment advisor at Shore Financial Services wants to develop a model that can be used to allocate investment funds among four alternatives: stocks, bonds, mutual funds, and cash. For the coming investment period, the company developed estimates of the annual rate of return and the associated risk for each alternative. Risk is measured using an index between 0 and 1, with higher risk values denoting more volatility and thus more uncertainty Investment R eturn (%) R isk Stocks 10 0.8 Bonds 3 0.2 Mutual funds 4 0.3 Cash 1 0.0 Because cash is held in a money market fund, the annual return is lower, but it carries essentially no risk. The objective is to determine the portion of funds allocated to each investment alternative in order to maximize the total annual return for the portfolio subject to the risk level the client is willing to tolerate. Total risk is the sum of the risk for all investment alternatives. For instance, if 40% of a client’s funds are invested in stocks, 30% in bonds, 20% in mutual funds, and 10% in cash, the total risk for the portfolio would be 0.40(0.8) 1 0.30(0.2) 1 0.20(0.3) 1 0.10(0.0) 5 0.44. An investment advisor will meet with each client to discuss the client’s investment objectives and to determine a maximum total risk value for the client. A maximum total risk value of less than 0.3 would be assigned to a conservative investor; a maximum total risk value of between 0.3 and 0.5 would be assigned to a moderate tolerance to risk; and a maximum total risk value greater than 0.5 would be assigned to a more aggressive investor. Shore Financial Services specified additional guidelines that must be applied to all clients. The guidelines are as follows: ● No more than 75% of the total investment may be in stocks. ● The amount invested in mutual funds must be at least as much as invested in bonds. ● The amount of cash must be at least 10%, but no more than 30% of the total investment funds. a. Suppose the maximum risk value for a particular client is 0.4. What is the optimal allocation of investment funds among stocks, bonds, mutual funds, and cash? What is the annual rate of return and the total risk for the optimal portfolio? b. Suppose the maximum risk value for a more conservative client is 0.18. What is the optimal allocation of investment funds for this client? What is the annual rate of return and the total risk for the optimal portfolio? c. Another more aggressive client has a maximum risk value of 0.7. What is the optimal allocation of investment funds for this client? What is the annual rate of return and the total risk for the optimal portfolio? d. Refer to the solution for the more aggressive client in part (c). Would this client be interested in having the investment advisor increase the maximum percentage allowed in stocks or decrease the requirement that the amount of cash must be at least 10% of the funds invested? Explain. e. What is the advantage of defining the decision variables as is done in this model rather than stating the amount to be invested and expressing the decision variables directly in dollar amounts?
This video solves the linear question using excel solver and excel formulas. For excel file please contact me on email: arunkumar9896@gmail.com WhatsApp +917357186374 Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Component 1 2 3 1 $12 $13 $14 2 $10 $11 $10 Each supplier has a limited capacity in terms of the total number of components it can supply. However, as long as Edwards provides sufficient advance orders, each supplier can devote its capacity to component 1, component 2, or any combination of the two components, if the total number of units ordered is within its capacity. Supplier capacities are as follows: Supplier 1 2 3 Capacity 600 1000 800 If the Edwards production plan for the next period includes 1000 units of component 1 and 800 units of component 2, what purchases do you recommend? That is, how many units of each component should be ordered from each supplier? What is the total purchase cost for the components? Chapter 4 Linear Programming Applications in Marketing, Finance, and Operations Management
This video solves the linear question using excel solver and excel formulas. For excel file please contact me on email: arunkumar9896@gmail.com WhatsApp +917357186374 The Atlantic Seafood Company (ASC) is a buyer and distributor of seafood products that are sold to restaurants and specialty seafood outlets throughout the Northeast. ASC has a frozen storage facility in New York City that serves as the primary distribution point for all products. One of the ASC products is frozen large black tiger shrimp, which are sized at 16-20 pieces per pound. Each Saturday ASC can purchase more tiger shrimp or sell the tiger shrimp at the existing New York City warehouse market price. The ASC goal is to buy tiger shrimp at a low weekly price and sell it later at a higher price. ASC currently has 20,000 pounds of tiger shrimp in storage. Space is available to store a maximum of 100,000 pounds of tiger shrimp each week. In addition, ASC developed the following estimates of tiger shrimp prices for the next four weeks: Week Price/lb 1 $6.00 2 $6.20 3 $6.65 4 $5.55 ASC would like to determine the optimal buying-storing-selling strategy for the next four weeks. The cost to store a pound of shrimp for one week is $0.15, and to account for unforeseen changes in supply or demand, management also indicated that 25,000 pounds of tiger shrimp must be in storage at the end of week 4. Determine the optimal buyingstoring- selling strategy for ASC. What is the projected four-week profit?
This video solves the linear question using excel solver and excel formulas. For excel file please contact me on email: arunkumar9896@gmail.com WhatsApp +917357186374 Epsilon Airlines services predominately the eastern and south eastern United States. The vast majority of Epsilon’s customers make reservations through Epsilon’s website, but a small percentage of customers make reservations via phone. Epsilon employs call center personnel to handle these reservations along with any problems with the website reservation system and for the rebooking of flights for customers if their plans change or their travel is disrupted. Staffing the call center appropriately is a challenge for Epsilon’s management team. Having too many employees on hand is a waste of money, but having too few results in very poor customer service and the potential loss of customers. Epsilon analysts have estimated the minimum number of call-center employees needed by day of week for the upcoming vacation season (June, July, and the first two weeks of August). These estimates are as follows: Day Employees Needed Monday 75 Tuesday 50 Wednesday 45 Thursday 60 Friday 90 Saturday 75 Sunday 45 The call-center employees work five consecutive days and then have two consecutive days off. An employee may start work any day of the week. Each call-center employee receives the same salary. Assume that the schedule cycles and ignore start-up and stopping of the schedule. Develop a model that will minimize the total number of call-center employees needed to meet the minimum requirements. Find the optimal solution. Give the number of call-center employees that exceed the minimum required.
This video solves the linear question using excel solver and excel formulas. For excel file please contact me on email: arunkumar9896@gmail.com WhatsApp +917357186374
This video solves the linear question using excel solver and excel formulas. For excel file please contact me on email: arunkumar9896@gmail.com WhatsApp +917357186374 The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and newspaper. Audience estimates, costs, and maximum media usage limitations are as shown. To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized. Constraint Television Radio Newspaper Audience per advertisement 100,000 18,000 40,000 Cost per advertisement $2000 $300 $600 Maximum media usage 10 20 10 a. If the promotional budget is limited to $18,200, how many commercial messages should be run on each medium to maximize total audience contact? What is the allocation of the budget among the three media, and what is the total audience reached? b. By how much would audience contact increase if an extra $100 were allocated to the promotional budget?
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and newspaper. Audience estimates, costs, and maximum media usage limitations are as shown. To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized. Constraint Television Radio Newspaper Audience per advertisement 100,000 18,000 40,000 Cost per advertisement $2000 $300 $600 Maximum media usage 10 20 10 a. If the promotional budget is limited to $18,200, how many commercial messages should be run on each medium to maximize total audience contact? What is the allocation of the budget among the three media, and what is the total audience reached? b. By how much would audience contact increase if an extra $100 were allocated to the promotional budget?
This video provides the solution for below linear question using excel solver and graph To get the solution file please message me on WhatsApp/telegram:+917357186374 Email:arunkumar9896@gmail.com
This video provides the solution for below linear question using excel solver and excel graph. To get the solution file: please message me on WhatsApp +917357186374 or email me on :arunkumar9896@gmail.com
This video provides the solution for below linear question excel solver and graph To get the solution file please message me on WhatsApp/telegram:+917357186374 Email:arunkumar9896@gmail.com A financial advisor at Diehl Investments identified two companies that are likely candidates for a takeover in the near future. Eastern Cable is a leading manufacturer of flexible cable systems used in the construction industry, and ComSwitch is a new firm specializing in digital switching systems. Eastern Cable is currently trading for $40 per share, and ComSwitch is currently trading for $25 per share. If the takeovers occur, the financial advisor estimates that the price of Eastern Cable will go to $55 per share and ComSwitch will go to $43 per share. At this point in time, the financial advisor has identified ComSwitch as the higher risk alternative. Assume that a client indicated a willingness to invest a maximum of $50,000 in the two companies. The client wants to invest at least $15,000 in Eastern Cable and at least $10,000 in ComSwitch. Because of the higher risk associated with ComSwitch, the financial advisor has recommended that at most $25,000 should be invested in ComSwitch. a. Formulate a linear programming model that can be used to determine the number of shares of Eastern Cable and the number of shares of ComSwitch that will meet the investment constraints and maximize the total return for the investment. b. Graph the feasible region. c. Determine the coordinates of each extreme point. d. Find the optimal solution. Transcript
This video provides the solution for below question To get the solution file: please message me on WhatsApp +917357186374 or email me on :arunkumar9766@outlook.com