Tutor Quora

ITECH1100 Understanding The Digital Revolution

Academic Anxiety?

Get an original paper within hours and nail the task

156 experts online

Free Samples

ITECH1100 Understanding The Digital Revolution

.cms-body-content table{width:100%!important;} #subhidecontent{ position: relative;
overflow-x: auto;
width: 100%;}

ITECH1100 Understanding The Digital Revolution

3 Downloads4 Pages / 805 Words

Course Code: ITECH1100
University: Federation University

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Question:
Task 1 – Costs of operating the business
 
Using Excel, create a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoing costs of running Fiction Oasis.Your spreadsheet should be configured such that the working hours, hourly rates, and fixed and utility costs can be varied easily.
 
Task 2 – Sales team offers
 
Using Excel, process the history of purchases spreadsheet and use appropriate charts to visualize:a.How the prices paid differed for each staff member; andb.How the prices paid have changed over timeDescribe your findings in your ePortfolio
Task 3 – Automation
 
Using Excel, create a spreadsheet page that automates the above process, allowing a member of the teamto enter whether the book is hardcover, its publication year, and its condition, and receive a price to offer. Ensure that you include enough text and formatting to make your spreadsheet usable by a member of the Fiction Oasis team, or by a University lecturer.
 
Your spreadsheet should be configured such that the Low, Medium and High prices can be varied easily.
 
Describe how you automated the process
 
Task 4 – Price setting
 
Using Excel and the historical data you have available, determine sets of prices which meet the objectives of the following scenarios:
Describe the strategy you used to find appropriate prices for each scenario.
Answer:

Task 1
Fiction Oasis is a small second-hand book shop, run by a team of three staff members: Archie, Bhavesh, and Celestine. All these three employees are working on three different time shift. For operating and managing their cost for the business they are using a excel sheet. This excel sheet will help them to manage their business cost. This speed sheet calculates the operating hours of every employee. Moreover, the total wags of each employee is also calculated in this excel sheet. An annual report is also calculating in this excel sheet.  Where Archie, Bhavesh is working for free and Celestine is working for $33 per hours.
Task 2
Fiction Oasis doing both sells and buy book from their customer. The customers are not coming for only buying the books instead of that they also selling their old books to the Fiction Oasis. The present staffs are reviewing the book and its condition and make an offer to the customer for buying the book. The price of the book is not fixed. It is different for each book by depending on their time, condition and current market. In this section the excel sheet is used calculate the average price for each staff and a histogram is created for staff wise and month wise.
The excel calculation is =AVERAGEIFS (I2:I481, E2:E481,”=Archie”, F2:F481,”=Poor”) for calculating the average price staff wise. The calculation is change in staff name and condition section. It is seeming that the Archie average price paid is 1.5, 4.5 and 0.3 for poor, good and terrible book condition. Bhavesh average price paid 0.9, 5.12, 0.2 for poor, good and terrible respectably. And the Celestine is 1.5, 6.1, 0.2.

Average Offer Staff Wise

Staff

Poor

Good

Terrible

Archie

1.518182

4.583333

0.335294

Bhavesh

0.956098

5.127027

0.211429

Celestine

1.592784

6.103896

0.20625

The excel calculation is =AVERAGEIFS (I1:I480, C1:C480,”=jul”, F1:F480,”=Poor”) for average in each month. Each month has different price. It is same as the above calculation that only condition and month is changed in each section.

Average Offer Month Wise

Month

Poor

Good

Terrible

Jul

1.364286

5.792857

0.227273

Aug

1.41831

5.42549

0.223333

Sep

1.454098

5.803922

0.25

Oct

1.412

5.121429

0.227273

Task 3
The staff of the book shop wants to improve their business process by understanding the book pricing. This task is about to creating an excel sheet which is shown their business process. They standardize their book offers by four types, those are rejects, low price, medium price, and high price. All this standers is depend on the book condition, publication year, book quality, and hardcover or paperback. This process is shown in the excel sheet by using formulas. The excel sheet formula is
=IF(F2=”Terrible”,”Rejected”,IF(F2=”Poor”,”Low Price”,IF(F2=”Good”,IF(G2<2002,"Low Price",IF(H2="Paperback","Medium Price","High Price"))))) In the above formula, if statement is use for apply the business process condition. First the formula will check the book condition that it is terrible, good or poor. If it is terrible then its directly reject the book. If it is in poor condition, then the price will be set as low price. If the condition is good, then it will process further. After determining the book condition is good it will check other things like publication date, new or old book and last it will check hardcover or paperback. If the book is older than 15 years then it will mark as low price and if the cover is paperback, then it will have marked as medium price and last if it is hardcover then it will have marked as high price. Task 4 This task has two scenarios. One scenario is total prices are same as historical data. This thing is calculated in the excel sheet. In excel only three price is calculated. First the average of high price is calculated and then calculate the actual selling price which is double of the buying price. The excel sheet result is below: Condition Average Offer Price High Prie 7.169767442 14.339535 Low Price 2.558064516 5.116129 Medium Price 4.095833333 8.1916667 Scenario two In scenario two an assumption is made. It is assuming that all books are purchased and all staff wage is same. This scenario is implement in the excel sheet. Scenario 2 Particulars Daily Working Hours Total Working Hours Hourly Wages Total Expenses Staff Salary         Archie 3.3 514.8 $22.00 $11,325.60 Bhavesh 3.3 514.8 $22.00 $11,325.60 Celestine 5 1300 $22.00 $28,600.00 Casual Staff 5 100 $33.00 $3,300.00 Total Salary     $54,551.20 Rent & Insurance     $2,900.00 Utilities Cost     $1,680.00 ANNUAL OPERATING COST     $59,131.20 Primary Operating Cost     $36,480.00 % of Increase in Operating Cost   62.09% Bibliography Dai, X. (2018). The digital revolution and governance. Routledge. Dioguardi, F., & Mele, D. (2015). A new shape dependent drag correlation formula for non-spherical rough particles. Experiments and results. Powder Technology, 277, 222-230. Gabor, D., & Brooks, S. (2017). The digital revolution in financial inclusion: international development in the fintech era. New Political Economy, 22(4), 423-436. Sharma, G. (2016). The CIEDE2000 color-difference formula. Excel spreadsheet implementation of the CIEDE2000 color-difference formula (including test data). Free Membership to World's Largest Sample Bank To View this & another 50000+ free samples. Please put your valid email id. E-mail Yes, alert me for offers and important updates Submit  Download Sample Now Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days. UploadUnique Document DocumentUnder Evaluation Get Moneyinto Your Wallet Total 4 pages PAY 2 USD TO DOWNLOAD *The content must not be available online or in our existing Database to qualify as unique. Cite This Work To export a reference to this article please select a referencing stye below: APA MLA Harvard OSCOLA Vancouver My Assignment Help. (2021). Understanding The Digital Revolution. Retrieved from https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/operating-the-business.html. "Understanding The Digital Revolution." My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/operating-the-business.html. My Assignment Help (2021) Understanding The Digital Revolution [Online]. Available from: https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/operating-the-business.html[Accessed 18 December 2021]. My Assignment Help. 'Understanding The Digital Revolution' (My Assignment Help, 2021) accessed 18 December 2021.

My Assignment Help. Understanding The Digital Revolution [Internet]. My Assignment Help. 2021 [cited 18 December 2021]. Available from: https://myassignmenthelp.com/free-samples/itech1100-understanding-the-digital-revolution/operating-the-business.html.

×
.close{position: absolute;right: 5px;z-index: 999;opacity: 1;color: #ff8b00;}

×

Thank you for your interest
The respective sample has been mail to your register email id

×

CONGRATS!
$20 Credited
successfully in your wallet.
* $5 to be used on order value more than $50. Valid for
only 1
month.

Account created successfully!
We have sent login details on your registered email.

User:

Password:

Are you falling behind than the rest of your class when it comes to programming? Are you struggling with the deadline of the coding assignments? Then, it is high time you bestow your faith in our programming help. We provide valuable insight into Python, C, and C++, and offer Java help to assist the students with intricate projects. Furthermore, we provide proofreading service so that the programs are left with no bugs. When it comes to writing lab reports, MyAssignmenthelp.com leaves no stone unturned and provides with accurate outputs for the programs.

Latest Management Samples

div#loaddata .card img {max-width: 100%;
}

MPM755 Building Success In Commerce
Download :
0 | Pages :
9

Course Code: MPM755
University: Deakin University

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answers:
Introduction
The process of developing a successful business entity requires a multidimensional analysis of several factors that relate to the internal and external environment in commerce. The areas covered in this current unit are essential in transforming the business perspective regarding the key commerce factors such as ethics, technology, culture, entrepreneurship, leadership, culture, and globalization (Nzelibe, 1996; Barza, 2…
Read
More

SNM660 Evidence Based Practice
Download :
0 | Pages :
8

Course Code: SNM660
University: The University Of Sheffield

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: United Kingdom

Answers:
Critical reflection on the objective, design, methodology and outcome of the research undertaken Assessment-I
Smoking and tobacco addiction is one of the few among the most basic general restorative issues, particularly to developed nations such as the UK. It has been represented that among all risk segments smoking is the fourth driving purpose behind infections and other several ailments like asthma, breathing and problems in the l…
Read
More
Tags:
Australia Maidstone Management Business management with marketing University of New South Wales Masters in Business Administration 

BSBHRM513 Manage Workforce Planning
Download :
0 | Pages :
20

Course Code: BSBHRM513
University: Tafe NSW

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answer:
Task 1
1.0 Data on staff turnover and demographics
That includes the staffing information of JKL industries for the fiscal year of 2014-15, it can be said that the company is having problems related to employee turnover. For the role of Senior Manager in Sydney, the organization needs 4 managers; however, one manager is exiting. It will make one empty position which might hurt the decision making process. On the other hand, In Brisba…
Read
More

MKT2031 Issues In Small Business And Entrepreneurship
Download :
0 | Pages :
5

Course Code: MKT2031
University: University Of Northampton

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: United Kingdom

Answer:
Entrepreneurial ventures
Entrepreneurship is the capacity and willingness to develop, manage, and put in order operations of any business venture with an intention to make profits despite the risks that may be involved in such venture. Small and large businesses have a vital role to play in the overall performance of the economy. It is, therefore, necessary to consider the difference between entrepreneurial ventures, individual, and c…
Read
More
Tags:
Turkey Istanbul Management University of Employee Masters in Business Administration 

MN506 System Management
Download :
0 | Pages :
7

Course Code: MN506
University: Melbourne Institute Of Technology

MyAssignmentHelp.com is not sponsored or endorsed by this college or university

Country: Australia

Answer:
Introduction
An operating system (OS) is defined as a system software that is installed in the systems for the management of the hardware along with the other software resources. Every computer system and mobile device requires an operating system for functioning and execution of operations. There is a great use of mobile devices such as tablets and Smartphones that has increased. One of the widely used and implemented operating syste…
Read
More
Tags:
Australia Cheltenham Computer Science Litigation and Dispute Management University of New South Wales Information Technology 

Next

Need an essay written specifically to meet your requirements?

Choose skilled experts on your subject and get an original paper within your deadline

156 experts online

Your time is important. Let us write you an essay from scratch

Tips and Tricks from our Blog

11174 Introduction To Management

Free Samples 11174 Introduction To Management .cms-body-content table{width:100%!important;} #subhidecontent{ position: relative; overflow-x: auto; width: 100%;} 11174 Introduction

Read More »