
This is the screenshot of the spreadsheet you are looking for.
I cant upload the spreadsheet file here. Please rate if you like it.
Type in all text and numbers shown in the spreadsheet below. Create formulae to display a...
Student Name Orca Industries Assignment Instructions: Below are the two most recent balance sheets and most recent income statement for Orca Industries. Create & complete a cash flow worksheet (NOT the actual Statement of Cash Flow)!! Type in your name in the blue highlighted area above. You MUST use cell references for your answers and format all currency as US $ with zero decimal places. There should be NO numbers simply type Use color/shading & borders to make your spreadsheet...
Follow the directions below to create an Excel graph for a perfectly competitive company. A company has total costs of 200+ 2000 - 2.5Q++ 1/3Q'. The price per unit is $500. Use excel to create a table to solve the problem as in question 5. Add two columns for average total costs and average variable costs. Create a graph for quantities from 1 to 25 that has ATC, AVC, MC, and MR on it. . Give the graph a title...
Objective: Text File I/0 and Regular Expressions Note that both classes below should handle all exceptions that might be thrown within them. 1. Create a class that does the following: a. Reads the name of a file to create as the first command line argument. (Overwrite any file with the same name). b. Reads an integer value as the second command line argument. C. The program should generate as many random numbers as are specified in the second command line...
This program is used to create a phonebook for storing contact information into a text file. The program begins by asking the user to provide a name for the file that will contain their phone book information. It will then ask the user to provide the names and numbers of their contacts. It should keep asking the user for contact information until they type in Done (case-sensitive). After the user types Done, store all contact information into the file name...
do numbers 4-8
4. Given any directory, use the Is command to display: • all files and sub-directories starting with the letter "D" (note do not list anything in any sub-directory) • its immediate sub-directories (sub-directories only, and no other ordinary files) its immediate hidden sub-directories only - take a screenshot (#3-3) that clearly shows the command and the result. 5. Assume that the following files are in the working directory: $ ls intro notesb ref2 section 1 section3 section4b...
In this project, you will work with sales data from Top’t Corn, a popcorn company with an online store, multiple food trucks, and two retail stores. You will begin by inserting a new worksheet and entering sales data for the four food truck locations, formatting the data, and calculating totals. You will create a pie chart to represent the total units sold by location and a column chart to represent sales by popcorn type. You will format the charts, and...
please show all work in Excel
CHAPTER 2: THE BASIC FINANCIAL STATEMENTS Homework for Chapter 2: Problem # 1 in the text (Chapter 2) Using the data presented below for Blue Sky Inc.: 2017 2016 S7,550,000 $6,150,000 5,750,000 Sales Cost of Goods Depreciation Selling and G&A Expenses Fixed Expenses Lease Expense Interest Expense 4,550,000 120,000 100,000 820,000 730,000 200,000 200,000 150,000 150,000 350,000 300,000 Tax Rate 40.00% 40.00% Shares Outstanding Cash Marketable Securities Accounts Receivable Inventory Prepaid Expenses Plant &...
Java I: Create a Java program that will accept the price of an item and the quantity being purchased of that item. After accepting the input, calculate the amount of the purchase (based on the price and quantity), calculate the sales tax on the purchase, then output the product price, quantity, subtotal, sales tax, and the total sale based on the output format shown below. Structure your file name and class name on the following pattern: The first three letters...
Java I - Write a program that will use static methods as described in the specifications below. Utilizing the if and else statements, write a program which will calculate a commission based on a two-tiered commission plan of 2% and 5% paid on amounts of $10,000 or less, or over $10,000 in monthly sales by a sales force paid on a commission basis. Use the output specifications below. --- (Please make detailed comments so I can better understand the code....
EA5-A2 Create a Bank Reconciliation for Tasters Club Corp. In this exercise, you will create a bank reconciliation for Tasters Club Corp. for the month ended December 31, 2016. The reconciliation should be partly based on these figures: Bank Statement Balance (12/31/2016) equals $16,200; Notes Receivable equals $395; NSF Check equals $4,000; Bank Charges equals $550. During the month, the bank erroneously deposited a $505 check written to Pepper Products into the bank account of Tasters Club Corp. 1. Open...