Utilizing a Data Warehouse to Analyze the Effects of Sales Type, Product Type, and Price on Net Profit in an F&B Outlet

Authors

  • Allegra Aretha Putri Business Information System Program, Faculty of Science and Technology, Pradita University, Indonesia
  • Nadine Aurelia Business Information System Program, Faculty of Science and Technology, Pradita University, Indonesia
  • Vera Veronika Business Information System Program, Faculty of Science and Technology, Pradita University
  • Fransiska Eka Putri Wiriady Business Information System Program, Faculty of Science and Technology, Pradita University, Indonesia
  • Rido Dwi Kurniawan Business Information System Program, Faculty of Science and Technology, Pradita University, Indonesia
  • Muh. Masri Sari Business Information System Program, Faculty of Science and Technology, Pradita University, Indonesia

DOI:

https://doi.org/10.31937/si.v16i2.4513

Abstract

This research aims to investigate how sales type, product type, and price influence net profit in an F&B outlet using a Data Warehouse system. A quantitative method was applied by integrating daily transaction data into a Data Warehouse architecture built through an Extract, Transform, and Load (ETL) process, allowing the data to be more organized and easier to analyze. To address heteroskedasticity and obtain more reliable coefficient estimates, multiple linear regression with HC3 robust standard errors was used. The results show that price and sales type have a significant and positive effect on net profit, while product type shows mixed effects depending on the category. The regression model, with an R² value of 0.994, indicates that these three variables explain most of the variation in net profit. Overall, the findings highlight how structured data processing through a Data Warehouse can support profitability analysis and improve decision-making in F&B operations.

Downloads

Download data is not yet available.

Downloads

Published

2025-12-30

How to Cite

Putri, A. A., Aurelia, N., Veronika, V., Wiriady, F. E. P., Kurniawan, R. D., & Sari, M. M. (2025). Utilizing a Data Warehouse to Analyze the Effects of Sales Type, Product Type, and Price on Net Profit in an F&B Outlet. Ultima InfoSys : Jurnal Ilmu Sistem Informasi, 16(2), 77–84. https://doi.org/10.31937/si.v16i2.4513

Issue

Vol. 16 No. 2 (2025): Ultima InfoSys : Jurnal Ilmu Sistem Informasi

Section

Articles

License

Copyright (c) 2025 Allegra Aretha Putri, Nadine Aurelia, Vera Veronika, Fransiska Eka Putri Wiriady, Rido Dwi Kurniawan, Muh. Masri Sari

Creative Commons License

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-ShareAlike International License (CC-BY-SA 4.0) that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.

Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.

Copyright without Restrictions

The journal allows the author(s) to hold the copyright without restrictions and will retain publishing rights without restrictions.

The submitted papers are assumed to contain no proprietary material unprotected by patent or patent application; responsibility for technical content and for protection of proprietary material rests solely with the author(s) and their organizations and is not the responsibility of the ULTIMA InfoSys or its Editorial Staff. The main (first/corresponding) author is responsible for ensuring that the article has been seen and approved by all the other authors. It is the responsibility of the author to obtain all necessary copyright release permissions for the use of any copyrighted materials in the manuscript prior to the submission.