Solve a model to determine where files should be stored

Assignment Help Financial Accounting
Reference no: EM131242242

List all steps and assumptions - Show the model, its solution, and your interpretation of the output. Provide guidance with the formulas in Excel spreadsheet, as well as in the Excel solver (constraints and formulas for results). Snapshots of it will work.

Currently, State University can store 200 files on hard disk, 100 files in computer memory, and 300 files on tape. Users want to store 300 word-processing files, 100 packagedprogram files, and 100 data files. Each month a typical word-processing file is accessed eight times; a typical packaged-program file, four times; and a typical data file, two times.

When a file is accessed, the time it takes for the file to be retrieved depends on the type of file and on the storage medium (see Table below). If the goal is to minimize the total time per month that users spend accessing their files, formulate and solve a model that can be used to determine where files should be stored.

Storage Medium

Time (Minutes)

Word Processing

Packaged Program

Data

Hard disk

5

4

4

Memory

2

1

1

Tape

10

8

6

Reference no: EM131242242

Questions Cloud

Write the mission statement of your company : Write the mission statement of your company, keeping in mind the benefits offered to customers rather than the product or service sold. If you are starting the online arm of a traditional store, should you make any changes to the company's overall..
Explain the impact technology have on role of a manager : Explain the impact technology and innovation have on the role of a manager. Develop a plan for your approach to management that includes the skills and attributes a manager must possess.
What are other keys to the potential success of your company : Begin a SWOT analysis by determining the primary strength of your company by asking, "What is the key differential or competitive advantage of my firm?" What are other keys to the potential success of your company? What other strengths can your fi..
Surface charge density of sphere : You now connect the spheres with a long thin wire. How are the final potentials V1 and V2 of the spheres related? Find the final charges q1 and q2. q1? q2? What is the ratio of the final surface charge density of sphere 1 to that of sphere 2?
Solve a model to determine where files should be stored : If the goal is to minimize the total time per month that users spend accessing their files, formulate and solve a model that can be used to determine where files should be stored.
Discuss the beauty in the everyday : Discuss the beauty in the everyday, not necessarily in the profound, but in the simple. Be creative, be thorough, and be true to these essays.
Write essay about flowcharting but rather to draw flowchart : You aren't being asked to write an essay about flowcharting, but rather to draw a flowchart. If your Case write-up doesn't contain a flowchart, then it's incomplete.
Have you observed major errors as result of false assumption : In your business experience, have you observed major errors as a result of false assumptions? What happened? Can you identify the point, or decision, of "no return" and suggest a possible alternative decision that may have brought a satisfactory r..
Prepare the adjusting journal entry for december : Prepare the adjusting journal entry for December 31, 2015 - Prepare the required adjust ingentry at December 31, 2015.

Reviews

Write a Review

Financial Accounting Questions & Answers

  The journal entry to record the first interest payment

On January 1, a company issues bonds dated January 1 with a par value of $300,000. The bonds mature in 5 years. The contract rate is 9%, and interest is paid semiannually on June 30 and December 31. The market rate is 8% and the bonds are sold for $3..

  Why are differences in reported amounts for deferred taxes

Why are differences in reported amounts for deferred taxes among the most frequent between the IFRS and the U.S., despite the fact that the two follow similar approaches for accounting for taxation?

  Insurance policy contract-compute present value

Julia Baker died, leaving to her husband Morgan an insurance policy contract that provides that the beneficiary (Morgan) can choose any one of the following four options. Money is worth 2.50% per quarter, compounded quarterly. Compute Present value i..

  Make a series of reports

Make a series of reports Whole period-end accounting activities (adjusting entries) Examine the firm via a series of questions (see the Check Your Progress- Project section of the project)

  Discuss the strategy the company uses to manage the exposure

Using major periodicals such as The Wall Street Journal, Financial Times, The Economist, or Bloomberg Business week, find a current example of operating/economic exposure. Identify the risk of your example economic exposure. Discuss the strategy the ..

  Compare and contrast company financial statements

Compare and contrast company financial statements and disclosure notes. Construct a table to provide the following information for each company.

  Evaluate financial performance

Income statement preparation On December 31, 2015, Cathy Chen, a self-employed certified public accountant (CPA), completed her first full year in business. During the year, she billed $360,000 for her accounting services. Depreciation expense on the..

  Capital project fund

The Capital Project Fund has just been created to account for resources received and expended for the construction of a new Health Center.

  Investors decided to sell their holdings of capital stock

Investors decided to sell their holdings of capital stock in order to purchase outstanding bonds payable and as a result, the prices of bonds payable increased.

  Use of worksheet in preparing statement of cash flows

Explain the use of a worksheet in preparing a statement of cash flows. When numerous adjustments are necessary or other complicating factors are present, companies often use a worksheet to assemble and classify the data that will appear on the statem..

  Create the 2016 pre-closing trial balance

Module 3 Assignment 1 Excel Workbook Assignment - Create the 2016 Pre-Closing Trial Balance for Been Carded, Ltd and Show calculations below your completed T-Accounts proving that your beginning and ending Accounting Equations balance.

  Compute the amount of bond interest expense to be reported

Compute the amount of bond interest expense to be reported on Peter Pan's income statement for the year ended December 31, 2014. (Round computations to the nearest dollar.)

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd